how do I compare two tables and find the differences

L

LostInSpace

I have two table with employees: SSN, Name, Address
The first table has past information and the second table has current
information. I need to be able to compare the tables and find out who has
had any changes to their information.
 
T

tina

try using an Unmatched query. you can build one easily enough with the help
of the Query Wizard.

hth
 
Top