How can I get Access to compare 3 different queries to create a table with all the duplicates?
Printable View
How can I get Access to compare 3 different queries to create a table with all the duplicates?
Need more details with example data and query.
Query 2001:
1
2
3
4
5
Query 2002:
4
2
6
8
1
20
58
Query 2003
100
10090
578
1
2
348
This is just to simplify the e.g. But, in actuality I have 100's of student numbers in each query. I need to determine which of the students(i) in Query 1, are found in Query 2 or 3 (ii)Query 2 in Query 3.
Thank you.
(i)
select distinct * from (
select Id from query1 where id in (select id from query2)
union
select Id from query1 where id in (select id from query3)
) as mytable
(ii)
select Id from query2 where id in (select id from query3)