Defining conditions for SQL statements in the SQL Query 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.
Before you begin
Before you begin, the SQL statement must be open in the SQL Query Builder.
About this task
You specify conditions for an SQL statement in a WHERE clause. Use the WHERE clause in SELECT, UPDATE, and DELETE statements to specify conditions for rows. You can define WHERE clauses in the SQL Query Builder on the Conditions page of the Design pane.
Procedure
To define a condition for an SQL statement in the SQL Query Builder: