Conditions page

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.
Related tasks
Defining conditions for SQL statements in the SQL builder
Creating expressions in the Expression Builder wizard

Feedback