Show only records in table A without matching records in table B

P

Paulo

I have 2 tables with a one-to-many relationship. I would like to create a
query that shows only those records in the main table (the "one" part in the
relationship) that DO NOT have matching records in the other.

Thanks in advance,

Paulo
 
O

Ofer Cohen

The best way will be using the query wizard to create an Unmatching records
query that will list all the records that are in one query but not in the
second table
 
Top