SQL/MX 2.x Reference Manual (H06.04+)

SQL/MX Statements
HP NonStop SQL/MX Reference Manual—540440-003
2-175
SELECT Statement
select-list is:
* | select-sublist [,select-sublist]...
select-sublist is:
corr.* | [corr.] single-col [[AS]name] |
[col-expr [[AS]name]
table-ref is:
table [[AS] corr [(col-expr-list)]]
| STREAM (table) [[AS] corr [(col-expr-list)]]
[AFTER LAST ROW]
| view [[AS] corr [(col-expr-list)]]
| STREAM (view) [[AS] corr [(col-expr-list)]]
[AFTER LAST ROW]
| (query-expr) [AS] corr [(col-expr-list)]
| (delete-statement [RETURN select-list])
[AS] corr [(col-expr-list)]
| (update-statement [RETURN select-list])
[AS] corr [(col-expr-list)]
| joined-table
access-option is:
READ UNCOMMITTED
| READ COMMITTED
| SERIALIZABLE
| REPEATABLE READ
| SKIP CONFLICT
| STABLE
query-expr is:
non-join-query-expr | joined-table
non-join-query-expr is:
non-join-query-primary | query-expr UNION [ALL] query-term
query-term is:
non-join-query-primary | joined-table
non-join-query-primary is:
simple-table | (non-join-query-expr)
joined-table is:
table-ref [NATURAL] [join-type] JOIN table-ref [join-spec]
|table-ref CROSS JOIN table-ref
join-type is:
INNER | LEFT [OUTER] | RIGHT [OUTER]
Pub/Sub
Pub/Sub
Pub/Sub