how to find records in one table which are not in another

  • Thread starter Thread starter Guest
  • Start date Start date
It would be an outer join. Here's an example:

Select Table1.MyID, Table1.OtherField
From Table1 Left Outer Join Table2 On Table1.Id = Table2.ID
Click to expand...
Where Table2.ID Is Null

In this example, the query will give you all records from Table1 that
are not in Table2.

Hope that helps!
 
Use the Unmatched query wizard (last option in the first dialog when you
create a query.)

It's an outer join with Is Null as critiera for the primary key of the
related table.
 

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

Have both records from two queries/tables under one Query without related fields. 0
not in criteria fails 2
NOT IN (SQL) or Find Unmatched (+ other stuff) 21
Itereate cross tab query over another query 0
Access Query to show records that do NOT meet join criteria 1
records that are in one table but do not have matches in another t 1
Finding records in one DB that are not in another 2
Transfer records from one table to another ? 3

Back
Top