Fragen ID: 2161 6/29
PREVIOUS QUESTION NEXT QUESTION

Create a query that will display only the OrderDate field from the Orders table, the Customer_Surname field from the Customers table and the Description field from the Products table.

Make sure the fields are displayed in the above order and all records of the Orders table are displayed even if there are not matching records in the Customers and Products tables. Save the query.

 

 

Other versions
Microsoft Access 2003Microsoft Access 2007Microsoft Access 2010Microsoft Access 2013Microsoft Access 2016Microsoft Access 365

 

 

 


Create a query that will display only the OrderDate field from the Orders table, the Customer_Surname field from the Customers table and the Description field from the Products table. 
Make sure the fields are displayed in the above order and all records of the Orders table are displayed even if there are not matching records in the Customers and Products tables. Save the query.