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

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

Post by UGF1bG » Sat, 17 Mar 2007 02:27:03


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
 
 
 

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

Post by T2ZlciBDb2 » Sat, 17 Mar 2007 02:34:49

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

--
Good Luck
BS"D