Add Subqueries

You can add one or more subqueries to further limit the tables and records returned from a SELECT statement when setting a WHERE, OR, or HAVING condition in the Query Builder.

To add a subquery

Select the Where, the Having, or the Or field in the column and click .
Click Subquery in the Condition editor. A new child Query Builder displays for you to use to build the subquery.
- The child (subquery) Query Builder window includes a Diagram pane, a Criteria pane, and a Queries pane for navigating back and forth between the subquery and the main query.
Drag tables or views to the subquery Diagram pane to build the subquery.
Define subquery criteria.
Click the Query node in the Queries pane to return to the main query window. A call-out in the main query Diagram pane indicates that the statement contains a subquery and identifies the column it is on. Hover over the call-out to view the subquery statement.

Tips:

To remove the subquery from the statement, right-click the subquery callout and select Delete.
To execute the subquery separately, right-click the subquery callout and select Open in Editor.