Comparing Queries

[NewtoSQL]

How can I get Access to compare 3 different queries to create a table with all the duplicates?

[MAK]

Need more details with example data and query.

[NewtoSQL]

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.

[MAK]

(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)