How to find duplicates records.

  • Thread starter Thread starter toyota58
  • Start date Start date
T

toyota58

I'm quite a newbie. I've created 2 tables and now I want to find
duplicates between these 2 tables. The first table have 1 field while
the other have 7 fields. I already did relationship between these 2
tables and did Find Duplicates Query but I don't seem to get
anything...

Thank You.
 
Should be pretty simple. Since the first table only has one field, I assume
you just want to find records in the second table that match on that single
field. Just bring both tables into your query, with an inner join on the
matching field, and display records from the second table (or both tables,
if you prefer).

The SQL for the query would be something like:

Select Table2.* From Table1 Inner Join Table2 on Table1.Field1 =
Table2.Field1

where "Field1" is the field that contains the same data in both tables.
 
Back
Top