Join Error

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi Im getting the error "(missing operator) in query expresion" .... it then
prints part of my join

Full text of the join from the immediate window is

SELECT r.ID, FirstName, LastName, Gender, DateDiff("yyyy",DateOfBirth,Now())
AS AgeNow, SocialClass, IIF(ISNULL(cr.CaseID),'','Short Listed') AS
ShortList FROM tblRespondent r LEFT JOIN tblCaseRespondent cr ON (r.ID =
cr.RespondentID AND cr.CaseID = 9) LEFT JOIN tblChild c ON (tblRespondent.ID
= tblChild.RespondentID)

Any ideas? I'm using ADODB and creating the sql inline

Thanks
Allen
 
Access tends to use non-standard SQL for joins.

I'd recommend building the query in the graphical builder, then getting the
SQL from there. I think you'll find it'll be something like

FROM Table1 LEFT JOIN (Table2 LEFT JOIN Table3 ON Table2.ID = Table3.ID) ON
Table2.ID = Table1.ID
 
Back
Top