Displaying records where they dont appear in another table.

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

Guest

I have table A with ID and Name as fields, I also have table B where some of
the same records appear. I would like to create an SQL stsement that would
return only records from table A where they do not appear in both tables.
Can anyone help????

Thanks in anticipation.
 
The query wizard includes assistance with an "unmatched" query.

Regards

Jeff Boyce
<Access MVP>
 
Back
Top