I have been trying to create a join using sql, however I cannot find specific enough examples of the sql. When I try to run it, I get 'A word is not recognized: SQL'. Does anyone see what I am doing wrong.
I am trying to add this into an existing fex to resolve a many to many join issue that I have.
TABLE FILE filename
SELECT field1, field2
ON TABLE HOLD AS table FORMAT FOCUS INDEXfield;