Double Left Joins In a Query

[mrfritz44]

In standard SQL, this would work:

SELECT * FROM PS
LEFT JOIN LW ON PS.C = LW.C AND PS.DEPTID = LW.DEPTID
LEFT JOIN DY ON PS.C = LW.C AND PS.DEPTID = DY.DEPTID
ORDER BY PS.C, PS.DEPTID, PS.D, PS.S

How can I make it work via Access?

Thank you,

Fred

 

[lespaul]

I don't think there's anything wrong with the query, maybe adding "access" parens would help?

SELECT * FROM (PS
LEFT JOIN LW ON PS.C = LW.C AND PS.DEPTID = LW.DEPTID)
LEFT JOIN DY ON PS.C = LW.C AND PS.DEPTID = DY.DEPTID
ORDER BY PS.C, PS.DEPTID, PS.D, PS.S

 

[PHV]

Anyway, JetSQL will choke here:
LEFT JOIN DY ON PS.C = [highlight]LW[/highlight].C AND PS.DEPTID = DY.DEPTID

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

 

[lespaul]

good spot! missed that!

the perils of copy and paste!

les


Leslie

Anything worth doing is a lot more difficult than it's worth - Unknown Induhvidual

Essential reading for anyone working with databases: The Fundamentals of Relational Database Design