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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Using Multiple Fields to Find Unmatched Records 5
Appending Data to a Table with 3 lookup Columns (Foreign Keys) 22
Insert records in Parent and child tables 5
Unable to add record to another realted table 2
Searching for parent in child-parent table 5
delete parent records where child fields are blank 2
Query that references a field ID(P_K) to filter data from other ta 1
Multi-table grouped query ungrouping - don't know why 4

Back
Top