I have three tables similar to the example below
T1 T3
------------------------ --------------------------
T1ID X ... T3ID Z ...
------------------------ --------------------------
1 aaa 1 abc
2 bbb 2 def
3 ccc 3 ghi
4 ddd 4 jkl
5 mno
T2
----------------------------------------
T2ID T1ID T3ID Y ...
----------------------------------------
1 1 1 eee
2 2 1 fff
3 3 1 ggg
4 2 2 hhh
5 2 3 iii
6 3 3 jjj
7 1 4 kkk
8 2 4 lll
9 3 5 mmm
10 4 5 nnn
What I want is an inner-join of all 3 tables but I only want the values in T3 selected if all of the values in T2 referencing the selected values in T1 are part of a previously established query. So for example if the previously established query (Q1) has T1ID's 1 and 2 selected then I want this query to select T3ID's 1 and 4. A typical join would select T3ID's 1, 2, 3, and 4 but I do not want T3ID's 2 and 3 selected because the values for T3ID 2 and 3 do not include T1ID 1 in T2. It is okay that T3ID 1 also contains other T1ID's in T2 for it to be selected. (I have no ability to change the database design so please no comments on changing it. Currently this database is in MS Access)