Query more than 1 table?

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

Guest

How do I query duplicate records from more than 1 table at a time

i.e. I have 3 tables from which I want to query records that duplicate on any 2 or 3

Thanks!
 
You can create a union query of all three tables using "UNION ALL". This
result behaves like a single table of all records. It isn't updateable but
you should be able to find duplicates.
 
How do I query duplicate records from more than 1 table at a time?

i.e. I have 3 tables from which I want to query records that duplicate on any 2 or 3.

Thanks!
Click to expand...

Ummm... why are you making your work more difficult for yourself!?

If you have three tables which might contain duplicate records, you
should STRONGLY consider combining them into one table.

To find duplicates you'll need a Query based on another Query. First
create a UNION ALL query to string together all three tables:

SELECT * FROM Table1
UNION ALL
SELECT * FROM Table2
UNION ALL
SELECT * FROM Table3

and then use the Duplicate Values query wizard *on this query*.
 
Back
Top