ExecuteSQL join on subquery
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?