8 Replies Latest reply on Jan 19, 2016 4:30 AM by Mike_Mitchell

    FM 11 ODBC RIGHT JOIN not working

    GarrettBanker_1

      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?