I am trying to build a query with more than one ORs in WHERE condition for constants. For example,
SELECT EMP.EMPLOYEE_ID
FROM EMPLOYEES EMP
WHERE ( (EMP.EMPLOYEE_ID = 100)
OR (EMP.EMPLOYEE_ID = 102) OR (EMP.EMPLOYEE_ID = 103)))
Query Builder's WHERE condition only allows for one constant. How can I insert more?
Use the Formula tab and not the Form tab in the 'OR' condition window to add multiple ORs in the WHERE clause.
1. From the Formula tab, select the the column from the 'Columns and Calculated Fields'
2. In the 'Operator' box double click on the operation you need to build your WHERE condition
See screen shot 883849_WHERE_CLAUSE.jpg