AnsweredAssumed Answered

ExecuteSQL join on subquery

Question asked by erawson on Jan 9, 2015


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?