Can you search a list using another list? 1

[mytaurus2000]

I'm using Access 2000.

If there is a SSN in the ORDERS table that is not in the CUSTOMER table I want to build a query that would return those values. Can this be done?

 

[Remou]

Have a look at the Find Unmatched Query Wizard.

 

[lespaul]

the quick and dirty way:

SELECT * FROM ORDERS WHERE SSN NOT IN (SELECT SSN FROM CUSTOMER)

Leslie

Essential for database developers:
The Fundamentals of Relational Database Design
Understanding SQL Joins

 

[mytaurus2000]

As usual, Remou it work perfectly. Thank you very much