Run with Dupes and Comparison together

[Kawg]

Goodaye!

I have two tables with about six fields each that I am doing comparison reports to weed out types, mostly.

I have updated each table's ID with three fields to anchor them together: e.g.,
TBL 1 last first MI Address zip TBL 2 last first mi address zip
1-15-b 1-15-b
1-22-4 1-22-4
44-6-2 44-6-2

The query has a <> to compare each of these fields. Trouble is: there are multiple occurances in the first table of the ID and only
one in the second.

Does anybody have any advice to include all occurances of the id in the first table when comparing it to the second. If I have to reconstruct the database, I will.

Any help is much appreciated. Thanks,

Kawg