Can you JOIN a Subquery

[Larsenal]

I am running Access 2002. I want to do something similar to the following:

SELECT * FROM tb1
LEFT JOIN
( SELECT tb2.ID AS tb2_ID, tb2.Author AS tb2_Author, tb2.Address AS tb3_Address
FROM tb2, tb3
WHERE tb2.Address = tb3.ID ) AS sb1
ON sb1.tb2_ID = tb1.Author

How can I do that? ---- to die is gain

[jasncab]

Yes you can really close to what you have already. You are joining from the sub out. and that should be ok. Its called a correlated sub query.. The problem is I dont see your point in this particular example. It could be that I am just missing it. But really you could just rewrite your example SELECT tb1.namedfields, AS tb2_ID, tb2.Author AS tb2_Author, tb2.Address AS tb3_Address FROM tb1 LEFT JOIN tb2.author ON FROM tb2.id = tb1.id left join tb3 on tb2.Address = tb3.ID http://www.jasncab.com/huberblog :: Jason Huber