joins

[brianh]

I have written a sql query that looks like the following but get an error saying that there us a syntax error in the join query. This is on Access 2000 using a vb front end..

Select * from tblEmp, tblSenders LEFT OUTER JOIN tblSenders on tblEmp.Site = tblSenders.Site and tblEmp.Logon_ID = tblSenders.Logon_ID where tblEmp.Logon_ID = " & "'" & user & "'" & " and tblEmp.site =" & "'" & offnum & "'"

[rjlohan]

I see you've used " to enclose the string variables. Try using a ' instead.
Also, I think the OUTER part of a LEFT JOIN is implied. Try doing LEFT JOIN instead of LEFT OUTER JOIN.

[rjlohan]

I suppose I should just write it...

Select * from tblEmp, tblSenders LEFT OUTER JOIN tblSenders on tblEmp.Site = tblSenders.Site and tblEmp.Logon_ID = tblSenders.Logon_ID where tblEmp.Logon_ID = " & "'" & user & "'" & " and tblEmp.site =" & "'" & offnum & "'"


Oh, hang on, I think I know... (You've JOIN tblSenders to tblSenders??)

Select * from tblEmp LEFT JOIN tblSenders on tblEmp.Site = tblSenders.Site and tblEmp.Logon_ID = tblSenders.Logon_ID where tblEmp.Logon_ID = '" & user & "' and tblEmp.site ='" & offnum & "'"