Database Guide
To specify the example WHERE clause
((WAGES.SALARY - WAGES.TAXES) > 3000) AND NOT (EMPLOYEE.AGE < 40)
do the following:
- In the Left operand field, select
WAGES.SALARY from the list.
- In the Operator field, select - from the
list.
- In the Right operand field, select
WAGES.TAXES from the list.
- Select Add to operand lists.
- In the Left operand field, select (WAGES.SALARY -
WAGES.TAXES) from the list.
- In the Operator field, select > from the
list.
- In the Right operand field, type 3000.
- Select Add to operand lists.
- In the Left operand field, select
EMPLOYEE.AGE from the list.
- In the Operator field, select < from the
list.
- In the Right operand field, type 40.
- Select Add to operand lists.
- In the Left operand field, select ((WAGES.SALARY -
WAGES.TAXES) > 3000) from the list.
- In the Operator field, select AND from the
list.
- In the Right operand field, select (EMPLOYEE.AGE
< 40) from the list.
- From the Unary operator pull-down menu, select Right
operand > NOT x.
[ Top of Page | Previous Page | Next Page | Table of Contents | Index ]