Defining conditions for SQL statements in the SQL builder

A search condition specifies a condition that is true, false, or unknown about a given row or group. The result of a search condition is derived by application of the specified logical operators (AND, OR, NOT) to the result of each specified predicate. If logical operators are not specified, the result of the search condition is the result of the specified individual predicate.

You specify conditions for an SQL statement in a WHERE clause or a HAVING clause. Use the WHERE clause in SELECT, UPDATE, and DELETE statements to specify conditions for rows. You can define WHERE clauses in the SQL builder on the Conditions page of the Design pane. Use the HAVING clause in a SELECT statement to specify conditions for groupings. You can define HAVING clauses in the SQL builder on the Group Conditions page of the Design pane.

Restriction: The use of parentheses in conditions is not supported.

Prerequisite: The SQL statement must be open in the SQL builder.

To define a condition for an SQL statement in the SQL builder:

  1. In the Design pane of the SQL builder, click the tab for the type of condition that you are defining:
    • If you are defining the condition for a row, click the Conditions tab.
    • If you are defining the condition for a grouping, click the Group Conditions tab.
  2. Double-click the first empty cell under the Column heading and select a column or type the expression for the condition. You can also click Build Expression in the list and use the Expression Builder wizard to create a complex expression.
  3. Double-click the adjoining cell under the Operator heading and select an operator for the condition.
  4. Double-click the adjoining cell under the Value heading and select a column or type a value or expression. A value is typically a numeric or string constant or a host variable. You can also select Build Expression in the list and use the Expression Builder wizard to create a complex expression.
Related tasks
Creating expressions in the Expression Builder wizard
Removing conditions from SQL statements in the SQL builder
Related reference
Conditions page

Feedback