Select all rows in a table that are different from another table?

M

mce

I want to compare two tables and list out the rows that are in one table and
not in the other. Does anyone know how to do this?
 
M

Marshall Barton

mce said:
I want to compare two tables and list out the rows that are in one table and
not in the other. Does anyone know how to do this?
Click to expand...


The query wizard knows how ;-)

Seriously, just create a new query and select the wizard for
Find Unmatched Query.
 
Top