join a subquery

[dragonwell]

How do I do this type of query in Access? I get invalid syntax errors.

select 
a.column,
b.column2

from Table1 a

left outer join
(select column1, column2 from Table2) b
on
a.ID = b.column1

Thanks

 

[PHV]

Have you tried this ?
select a.column, b.column2
from Table1 a left join
(select column1, column2 from Table2) b
on a.ID = b.column1
BTW, which version of access ?

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[dragonwell]

no go, either.

it's 2003.


Anyway - I'm actually querying ODBC linked FoxPro tables , which DOES NOT support subqueries in the FROM clause, so it's a lost cause. Thanks anyway

 

[PHV]

Simply use saved queries you can then join.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[dragonwell]

Can I save a query via SQL? I.E. "CREATE VIEW ..." or somthing?

Thanks..