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:
The SELECT statement is displayed in the SQL statement field.
Specifying a new nested SELECT statement
To specify a new nested SELECT statement:
The SELECT statement is displayed in the SQL statement field.