How Do I ... : Work with databases : Use the SELECT Details window : Specify a nested SELECT statement
Specify a nested SELECT statement
Specify a WHERE clauseSpecify a WHERE clauseNo tip for this topicNo example for this topicSpecify a GROUP BY clauseSpecify a GROUP BY clause
A nested SELECT statement is a SELECT statement nested within another SQL statement.
The nested SELECT statement you specify can be either an existing SELECT statement or a new one.
Specifying an existing nested SELECT statement  
To specify an existing nested SELECT statement:
1. Select the access set that contains the SELECT statement you want to use.
2. Select the SELECT statement you want to use.
The SELECT statement is displayed in the SQL statement field.
Specifying a new nested SELECT statement  
To specify a new nested SELECT statement:
1. Select the access set in which you want to create the new SELECT statement.
2. Select Create.
3. In the SELECT Details window, specify the SELECT statement and select Apply.
4. Select the SELECT statement you just created, if it isn't already.
The SELECT statement is displayed in the SQL statement field.
Last modified date: 08/13/2019