SQL syntax
SQL syntax
(OP)
Yes, I am new too.
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.
I have:
TABLE FILE filename
SQL
SELECT field1, field2
FROM filename
WHERE criteria;
END
ON TABLE HOLD AS table FORMAT FOCUS INDEXfield;
END
Thanks
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.
I have:
TABLE FILE filename
SQL
SELECT field1, field2
FROM filename
WHERE criteria;
END
ON TABLE HOLD AS table FORMAT FOCUS INDEXfield;
END
Thanks
RE: SQL syntax
SQL
SELECT field1, field2
FROM filename
WHERE criteria;
TABLE
ON TABLE HOLD AS table FORMAT FOCUS INDEXfield
END
this will work fine.
RE: SQL syntax