Tchater maintenant avec le support
Tchattez avec un ingénieur du support

Toad Data Studio 1.1 - User Guide

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.

For additional help with subqueries, see the Tutorial: Build a Subquery

To add a subquery

  1. Select the Where, the Having, or the Or field in the column and click .

  2. 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.

  3. Drag tables or views to the subquery Diagram pane to build the subquery.

  4. Define subquery criteria.

  5. 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.

 

Related Topics

Build Queries Visually  

Documents connexes

The document was helpful.

Sélectionner une évaluation

I easily found the information I needed.

Sélectionner une évaluation