i want to compare two tables and find duplicates

[dsparnicht]

I have two tables with same headings and similar data, i want to compare the
two tables to find how many of the rows are the same on both tables.

 

[Duane Hookom]

Do all of the fields have to be the same? Are there primary keys?