How Do I...

Specify a nested SELECT statement

Specify a WHERE clause No tip for this topic No example for this topic Specify 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.


[ Top of Page | Previous Page | Next Page | Table of Contents ]