To combine conditions with AND, you put the conditions in the same column of the Grid pane. To combine conditions with OR, you put the first one in the Criteria column and additional conditions into an Or … column.
For example, imagine that you want to find either employees who have been with the company for more than five years in lower-level jobs or employees with middle-level jobs regardless of their hire date. This query requires three conditions, two of them linked with AND:
-or-
The following procedure illustrates how to create this type of query in the Grid pane.
To combine conditions when AND has precedence
hire_date
and job_lvl
columns, enter values as shown here:
These grid entries produce the following WHERE clause in the statement in the SQL pane:
WHERE (hire_date < '01/01/91') AND
(job_lvl = 100)
job_lvl
column, enter an additional value as shown here:
Adding a value in the Or … column adds another condition to the WHERE clause in the statement in the SQL pane:
WHERE (hire_date < '01/01/91' ) AND
(job_lvl = 100) OR
(job_lvl = 200)