Use the grid on this page to specify the conditions that control
which rows of the database to select, update, or delete, depending on the
type of statement that you are creating.
The conditions for an SQL statement are specified in a WHERE clause
or a HAVING clause.
- Column
- This column can contain either a table column
or an expression. To enter an expression, click Build Expression in
the list, and then use the pages of the Expression Builder wizard to specify
the expression.
- Operator
- Select an operator for the condition.
- Value
- This column can contain a column, value, or expression. Double-click
the cell to type a value, select a column, or click Build Expression to
open the Expression Builder wizard.
- AND/OR
- If you need multiple conditions in the WHERE clause,
select either AND or OR as the logical connective between each condition.