Difference Query

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?
 
J

Joe Fallon

Use the Find Unmatched Query Wizard and then read the SQL to see how it is
done.
 

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

Extracting a cell value 2
External cell reference between two excel worksheets both in One Drive 0
Sub projects added as read only in Master file which are saved on sharepoint 1
Finding records in one DB that are not in another 2
Append Crosstab Query to Existing Table 0
Visio: copy text of a master shape to User-define Cells (Variable) 0
Trying to create a report that will list unmatched records by Ticket Primary Key 0
How to extract records matching a list of strings? 7

Top