How to define a subquery in the SQL pane (Enterprise Manager)

To define a subquery in the SQL pane

1. Create the primary query.
2. In the SQL pane, select the SQL statement, and then use the Copy command to move the query to the Clipboard.
3. Start the new query, and then use the Paste command to move the first query into the new query’s WHERE or FROM clause.