AND and OR

LANSA

AND and OR
All about SELECT_SQLThe Things that Make Up this ExampleTo Execute this ExampleForms/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.'')')




TypeNameCodeDescription
FunctionSET189CSET189CSELECT_SQL - AND and OR
Form S_189FCS_189FCSELECT_SQL - AND and OR