Specify a nested SELECT statement

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: 01/29/2015