Question ID: 6587 9/22
PREVIOUS QUESTION NEXT QUESTION

Create a new query that will use the Description and Price fields from the Products table and the FilePath field of the ProductsPhoto table. Apply a criterion to the FilePath field to retrieve all records containing a photo. Make sure that when the query is executed the Description and Price fields only (following this order) are displayed. Save the query as q1 and close it.

 

 

Other versions
OpenOffice.org Base 3.3LibreOffice Base 4.0

 

 

 


Create a new query that will use the Description and Price fields from the Products table and the FilePath field of the ProductsPhoto table. Apply a criterion to the FilePath field to retrieve all records containing a photo. Make sure that when the query is executed the Description and Price fields only (following this order) are displayed. Save the query as q1 and close it.