Syntax error in JOIN operation 1

[jslmvl]

Hi,

Can you tell me what is wrong:

sql = "Select * From Table1 Left Join (Select Table2.[User] From Table2 Group By Table2.[User]) On Table1.[User]=Table2.[User] "

I got "Syntax error in JOIN operation

 

[Remou]

You must use an alias for the subquery, try:

Select * From Table1 Left Join (Select Table2.[User] From Table2 Group By Table2.[User]) As t On Table1.[User]=t.[User]

http://lessthandot.com

 

[jslmvl]

Yes you are absolutely right!