Find duplicate records in multiple tables.

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi, Can anyone point me in the right direction to solving this?

I have a Table which is a parent table with and Primary key ID and data.

I can find duplicate data just fine for that.

There is also a child table for Details which references that primay key in
the parent table and also has its own primary key and data.

There are cases when the data in the parent table is the same but the data
in the child table is sometimes different and I do not know of a way to check
if all child rows are the same or not.
 
Start by building a query that inner-joins the two tables and returns
the fields you're interested in. Then create a "find duplicates" query
that gets its data from the first query.
 
Back
Top