Records from 1 table that do NOT have a match in a second

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

How do I create a query to include all the docs from table1 that don't have
matches in table2?
For example:
Table 1
IDs: 1,2,3,4
Table 2
ID: 3
Yields IDs 1,2,4

Thanks
Steve
 
Hello Rick:

I don't find any option for an "unmatched" query. How do I do this?

Thanks

Steve
 
Go to the query tab of your database.

Click the "New" button

In the New Query Dialog Box, select "Find Unmatched Query Wizard".
 
Thanks Rick. That does it.

Steve

Rick B said:
Go to the query tab of your database.

Click the "New" button

In the New Query Dialog Box, select "Find Unmatched Query Wizard".
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Query on two tables with matching null fields 4
Update a field from 1 through 10 6
Create a distinct Join 3
recursively retrieve records from 2nd table based on records from 1
Extract trades that do NOT match the other table 2
Left Join to Huge Table with Duplicates 1
Have both records from two queries/tables under one Query without related fields. 0
swapping data from one table to another 3

Back
Top