Defining criteria

To define criteria, you may use the Criteria and all of the Or columns of the Columns Pane.

In these cells you should write conditions omitting the expression itself. For example to get the following criterion in your query:

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

you would type

">= 10 AND <= 20 " in the Criteria cell of the Field1 expression.

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, this visual representation will produce the following SQL statement. Note that criteria for Field1 are 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 the NOT operator before the expression.