QuerySelect

Each query is composed of one or more select statements:

Field or Control Description

Main Select

The instance of the first SELECT statement of the Query is the Main Select. There can only be one Main Select statement in the Query. This instance consists of the QueryOutputFIelds, QueryCriteria, and the QueryExpressions for the Main Select statement.

Union

In addition to the Main Select, a query can have one or more unions. The Unions are added by using the AddUnion method.

Sub-Select

A subquery used in the criteria of the Main Select or in a Union.