Lesson 6.11. Finding Unmatched RecordsFigure 6-22. Select the table or query with the values you want to display in the query.Figure 6-23. Specify the field that will join the records in the first table to the records in the second table.Figure 6-24. The query displays those records in the Customers table that do not have any matching records in the tblCustomerTours table.The helps you find the records in one table that do not have matching records in another table. Some scenarios when you might need to create such a query include:
In this lesson you will use the Find Unmatched Query Wizard to create a query to find customers who have never booked a tour.
|