Compare Two Tables

[retired fire]

Sorry for the second post, but (after creating 50 or 60 unmatched queries) I
am still not able to get one right.... John Spencer has helped me with the
learning curve per previous post....

Table 1 (master table), has 25 fields, but I have narrowed the fields
needed to be included in the unmatched query to 6

Fields are: Dues, PAC, SS#, Last Name, First Name, Middle Initial

Table 2 (update), contains the same fields as Table 1

NEED Unmatched Query to return:

New records in Table 2 that are not in Table 1.
Records in Table 1 that are not in Table 2.
Any data in any field on any record in Table 2 that does not equal those in
Table 1.
(Note- The Middle Initial field has no data entry on some records, as the
person has no middle initial).. Unique field is SS#

Hope some more help is available....FYI Table 1 being the master table,
needs to include updated information I receive each month (table2). Table 2
will include new records, and will also show changes in records (such as
address change, etc), and also will have some records removed that need to be
deleted from Table 1.

Any SQL held would be greatly appreciated....

 

[knightconsulting]

i had a similar problem and wrote firefly to do the work for me
www.getfirefly.net