Difference between 2 identical tables.

[leepan2008]

Access Gurus,

I have 2 identical tables in Access. They ideally should have same data but as nothing in this world is ideal so are the tables. There are discrepancy between 2 tables and they are not an exact match. I want to find out which rows in table 2 are not present in table 1.

I have tried may queries but nothing seems to work.

Just to make things easier for people who use oracle I want a functionality something like

select * from  A
minus 
select * from B.

Any help will be highly appreciated.

Thanks a lot.
Lee

[RuralGuy]

Try the unmatched query wizard.