Difference Query

  • Thread starter Thread starter Dennis Lawrence
  • Start date Start date
D

Dennis Lawrence

I have a master table and a subset table where the subset
is a list of some of the records in the master.

How do I query so that the query result is a list of the
records from the master that do not exist in the subset?
 
Use the Find Unmatched Query Wizard and then read the SQL to see how it is
done.
 
You must log in or register to reply here.

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

Finding records in one DB that are not in another 2
#error results in unmatched records of outer join 9
How to extract records matching a list of strings? 7
Probably A Stupid Query Question 3
Compare 2 columns and show differences... 2
Linking a key that is a subset of key on next table 2
'Into the Breach' strategy game review 3
Filtering table depending on criteria 5

Back
Top