This section describes how to use the DB/Assist statement construction dialog boxes to build a SQL SELECT statement. A SELECT statement retrieves one or more rows of data from a single or multiple tables.

With DB/Assist, you can build two forms of SELECT statements:

•A multi-row SELECT statement retrieves multiple rows of data and generates cursor-based ESL action routines when you compile the SAM.

•A single-row SELECT statement retrieves a singe row of data and assigns the values in that row to ESL variables.

In most cases, you will use the DB/Assist dialog boxes to build multi-row SELECT statements. The following topics:

•Building a Basic SELECT Statement

•Adding a Computed Column

•Adding a WHERE Clause

•Adding a Join Clause

•Adding a GROUP BY Clause

•Adding an ORDER BY Clause

use a variety of sample multi-row SELECT statements to illustrate how to build a basic SELECT statement and then refine it as needed by adding one or more of the following:

•Computed column

•WHERE clause

•Join clause

•GROUP BY clause

•ORDER BY clause

For information about how to build a single-row SELECT statement, see Building a Single-Row SELECT Statement.