can not find input table or query

[mygmat123]

I'm having trouble with this SQL.


SELECT table1.*
FROM table1 LEFT JOIN [SELECT * FROM table2 WHERE field1="12345"] AS alais2 ON table1.field2=alais2.field3;


When I run this with no join it works fine, but when I add a left join, I get the error.....

"The Microsoft jet database engine cannot find the input table or query "SELECT * FROM table2 WHERE field1="12345"" Make sure it exists and that its name is spelled correctly."

I know "SELECT * FROM table2 WHERE field1="12345"" is a valid sql statement because I can run it fine alone. What am I missing?

thank you

 

[PHV]

The subquery must be between parens, not brackets.

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