WHERE clause
To specify the example WHERE clause
((WAGES.SALARY - WAGES.TAXES) > 3000) AND NOT (EMPLOYEE.AGE < 40)
do the following:
1. In the Left operand field, select WAGES.SALARY from the list.
2. In the Operator field, select - from the list.
3. In the Right operand field, select WAGES.TAXES from the list.
4. Select Add to operand lists.
5. In the Left operand field, select (WAGES.SALARY - WAGES.TAXES) from the list.
6. In the Operator field, select > from the list.
7. In the Right operand field, type 3000.
8. Select Add to operand lists.
9. In the Left operand field, select EMPLOYEE.AGE from the list.
10. In the Operator field, select < from the list.
11. In the Right operand field, type 40.
12. Select Add to operand lists.
13. In the Left operand field, select ((WAGES.SALARY - WAGES.TAXES) > 3000) from the list.
14. In the Operator field, select AND from the list.
15. In the Right operand field, select (EMPLOYEE.AGE < 40) from the list.
16. From the Unary operator pull-down menu, select Right operand > NOT x.
Last modified date: 01/29/2015