How to define an EXISTS subquery in the Grid pane (Enterprise Manager)

To define an EXISTS subquery in the Grid pane

1. Create the primary query.
2. In the Column column for the first empty row in the Grid pane, enter EXISTS followed by the subquery in parentheses.
3. In the Criteria column for the row containing the subquery, enter TRUE, FALSE, =TRUE, or =FALSE. Entering FALSE or =FALSE results in a NOT EXISTS query.

Note To create a NOT EXISTS query, create an EXISTS query as listed in the above steps, and set the Criteria column to FALSE. If you enter NOT EXISTS in the Grid pane, the Query Designer will display an error.

If you enter a subquery in the SQL pane, you will probably find it easier to use Cut and Paste commands to create the query.