How to combine conditions when AND has precedence (Enterprise Manager)

To combine conditions when AND has precedence

1. In the Grid pane, add the data columns you want to search. If you want to search the same column using two or more conditions linked with AND, you must add the data column name to the grid once for each value you want to search.
2. In the Criteria column, enter all the conditions that you want to link with AND.
3. In the Or ... grid column, enter conditions that you want to link with OR.

   Adding a value in the Or ... column adds another condition to the WHERE clause in the statement in the SQL pane.