Query more than 1 table?

[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!

 

[Duane Hookom]

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.

 

[John Vinson]

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!

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*.