Subquery
You can add a Subquery tab to an existing query when you need to nest queries so the output of the nested query becomes an input to the enclosing query. Subqueries can be found in the following locations:
- In a Query Flow tab (after you insert a Subquery object into a Query Flow Editor)
- In an Inner Join, Left Join, Right Join, or Full Join tab (using the drop-down menu in an Operand field)
- In a Select, Where, or Having tab (using the drop-down menu in an Operand field)
When you open a subquery, a Query Flow tab is displayed. You can build the subquery that you need and run it within the enclosing query. See Query Flow Tab for more information.