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

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

Guest

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
 
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
 
Back
Top