Defining Criteria - 23.1

To define criteria, use the Criteria column and the Or columns of the Columns pane. When writing conditions in these columns, omit the expression itself. For example, to get the following criteria in your query:

WHERE  (Field1 >= 10) AND (Field1 <= 20)

Type the following in the Criteria cell of the Field1 expression:

>= 10 AND <= 20

Criteria placed in the Or columns will be grouped by columns using the AND operator and then concatenated in the WHERE (or HAVING) clause using the OR operator. For example, the criteria shown below will produce the SQL statement below. Please note that criteria for Field1 is placed both to the Criteria and Or columns.

WHERE (Field1= 10) AND ((Field2 < 0) OR (Field2 > 10))

Some expressions may be of Boolean type, for example the EXISTS clause. In this case you should type "= True" in the Criteria column of such expressions or "= False" if you want to place a NOT operator before the expression.