Join

LANSA

Join
All about SELECT_SQLThe Things that Make Up this ExampleTo Execute this ExampleForms/Components for this Example

Function SET189E or form S_189FE

You can join files before retrieving the data:


SELECT_SQL FIELDS((#EMPNO PSLMST.EMPNO) #SKILCODE #DATEACQR) FROM_FILES((PSLMST)(PSLSKL)) WHERE('PSLMST.EMPNO=PSLSKL.EMPNO AND SKILCODE=''4GL''') ORDER_BY(DATEACQR);




TypeNameCodeDescription
FunctionSET189ESET189ESELECT_SQL - Joins
Form S_189FES_189FESELECT_SQL - Joins