Table comparisons

E

es

create a new query and use the wizard and the UnMatched
Query builder.

-----Original Message-----
Need some help sifting through some data. I have one
database with two tables (A and B). Both tables contain
only one Field. Table A has 350,000 entries, and Table B
containes 355,000 entries. 350,000 entries from both
tables are the same, the other 5,000 are not. I need to
find these 5,000 entries. Rather than having to manualing
comparing line by line, is there a way to get a list of
the 5,000 fields that are different. Thanks in advance for
the assistance.
 
Top