AND and OR
| All about SELECT_SQL | The Things that Make Up this Example | To Execute this Example | Forms/Components for this Example |
Function SET189C or form S_189FC
You can use AND and OR operators to construct complex queries:
SELECT_SQL FIELDS(#EMPNO #SURNAME #ADDRESS2 #SALARY) FROM_FILES((PSLMST)) WHERE('((SALARY > 15000) AND (SALARY < 30000)) OR (ADDRESS2 = ''SEVEN HILLS.'')')
You can use AND and OR operators to construct complex queries:
SELECT_SQL FIELDS(#EMPNO #SURNAME #ADDRESS2 #SALARY) FROM_FILES((PSLMST)) WHERE('((SALARY > 15000) AND (SALARY < 30000)) OR (ADDRESS2 = ''SEVEN HILLS.'')')
| Type | Name | Code | Description |
| Function | SET189C | SET189C | SELECT_SQL - AND and OR |
| Form | S_189FC | S_189FC | SELECT_SQL - AND and OR |