0 Replies Latest reply on Jan 9, 2015 12:02 PM by erawson

    ExecuteSQL join on subquery



      ExecuteSQL join on subquery


      Hi all,

      I am attempting to perform a join on a subquery like follows:

      SELECT 1, hello FROM table JOIN ( SELECT 1 as hello FROM table ) AS test ON 1=1

      However filemaker tells me that I have a syntax error. I tested this syntax and it works in mysql and sql server. Does anyone know if this is a limitation of the filemaker sql engine or does it use a different syntax?