SELECT

Describe the fields to be compared in selecting records

SELECT conditional_spec

conditional_spec

Specifies a condition or set of conditions in a report. The maximum number of conditions for a selection statement is 25. See Condition_spec definition.

The SELECT statement describes the field(s) to be used and compared in selecting the records for a report.

A selection entry enables a user to choose which records should be included in a report.

In the following example, only records that have the same city and state as TEMP.CITY and TEMP.STATE will be included in the report.

SELECT CUST_TAG.CITY EQ TEMP.CITY AND
CUST_TAG.STATE EQ TEMP.STATE

In the example below, only records that have customer identification numbers greater than 200 and an item identification number of 13 will be included in the report.

SELECT CUST_ID GT "200" AND
ITEM_ID EQ "13"