SELECT
Describe the fields to be compared in selecting records
SELECT conditional_spec
Arguments
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.
Discussion
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.
Examples
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"