Multiple ON Clauses within RIGHT JOIN

[Jackpotgee]

Hi

Can anyone tell me if it is possible to use multiple On clauses within a RIGHT or LEFT JOIN. If so why is this part of the query giving me such issues? Have i got the sytax completely wrong?


FROM Qry_SelectMatterFeesFromCMS RIGHT JOIN Qry_ReportReferralsLocation
ON Qry_SelectMatterFeesFromCMS.FeeInfoMatterNumber = Qry_ReportReferralsLocation.MatterNumber AND
ON Qry_SelectMatterFeesFromCMS.FeeInfoID = Qry_ReportReferralsLocation.ID

Any help will be hugely appreciated. I've pulled out so much hair today it's scarey.

Cheers

[Jackpotgee]

I am running this query in Microsoft Access 2003 if that helps

[chazzy]

the proper syntax should be

ON (clause) [and ... (clause) ]*