Recordset Intersection In Access

I'm trying to find the intersection of recordsets that result from two SELECT queries, but (to the best of my meager knowledge) Access doesn't support the INTERSECT clause.

Are there alternative ways to perform this operation in a single query? I read a few posts that suggested LEFT JOIN, but I am not sure about how to combine a left join w/ the inner joins I am using to retrieve my data.

My SQL statement would read as follows if Access supported INTERSECT:

~~~~
SELECT * FROM
(Table1 INNER JOIN Table2 On Table1.A = Table2.B)
INNER JOIN Table3 ON Table2.C = Table3.D
WHERE (Table1.X = True) AND (Table3.Y = True)

INTERSECT

SELECT * FROM
(Table1 INNER JOIN Table2 On Table1.A = Table2.B)
INNER JOIN Table3 ON Table2.E = Table3.D
WHERE (Table1.X = True) AND (Table3.Y = True)
~~~~