Auto Join

LANSA

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

Function SET189F or form S_189FF

You can join a table to itself to compare data:


SELECT_SQL FIELDS((#EMPNO P2.EMPNO) (#SURNAME P2.SURNAME) (#SALARY P2.SALARY)) FROM_FILES((PSLMST P1)(PSLMST P2)) WHERE('P1.EMPNO=''A1234'' AND P2.SALARY > P1.SALARY')




TypeNameCodeDescription
FunctionSET189FSET189FSELECT_SQL - Joining a file to itself
Form S_189FFS_189FFSELECT_SQL - Joining a file to itself