Auto Join
| All about SELECT_SQL | The Things that Make Up this Example | To Execute this Example | Forms/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')
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')
| Type | Name | Code | Description |
| Function | SET189F | SET189F | SELECT_SQL - Joining a file to itself |
| Form | S_189FF | S_189FF | SELECT_SQL - Joining a file to itself |