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 & "'"