how do I compare two tables and find the differences

[Guest]

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.

 

[tina]

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

hth