Full-Select Statement

A full-select statement specifies a result table. If UNION is not used, the result of the full-select is the result of the specified subselect.

Following is the syntax diagram for the full-select statement:

   ┌─ choice ────┐
►►─▼─ subselect ─┴─────────────────────────────────────────────────────────────►◄

Expansion of Where choice is as follows

├──┬─ UNION ─────┬─────────────────────────────────────────────────────────────┤
   └─ UNION ALL ─┘