SQL syntax

[ds50137]

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

 

[simaccs]

try to change your request such this.

SQL
SELECT field1, field2
FROM filename
WHERE criteria;
TABLE
ON TABLE HOLD AS table FORMAT FOCUS INDEXfield
END

this will work fine.

 

[ds50137]

Thanks! I will give it a try.