AnsweredAssumed Answered

FM 11 ODBC RIGHT JOIN not working

Question asked by GarrettBanker_1 on Nov 21, 2012
Latest reply on Jan 19, 2016 by Mike_Mitchell

Title

FM 11 ODBC RIGHT JOIN not working

Your post

     Ok so I can run this query fine (via ODBC + PHP) and I'm getting results:

      

select NonReg.firstName as NonRegfirstName, NonReg.lastName as NonReglastName, NonReg.email as NonRegemail, NonReg.regStatus as NonRegregStatus, MAIN.status, MAIN.key_recordID, MAIN.regFee, MAIN.conferenceFeeAgree, MAIN.cancellationAgree from "NonReg" LEFT JOIN "MAIN" on MAIN.email = NonReg.email

      

However, if I change the query to a RIGHT JOIN instead of LEFT JOIN, it tells me: "[FileMaker][FileMaker] FQL0001/(1:1012): There is an error in the syntax of the query."

      

select NonReg.firstName as NonRegfirstName, NonReg.lastName as NonReglastName, NonReg.email as NonRegemail, NonReg.regStatus as NonRegregStatus, MAIN.status, MAIN.key_recordID, MAIN.regFee, MAIN.conferenceFeeAgree, MAIN.cancellationAgree from "NonReg" RIGHT JOIN "MAIN" on MAIN.email = NonReg.email

      

     Is there something I am doing wrong, does FM11 not support right join's?

Outcomes