...
- A SELECT statement can be part of a union query or a subquery of another query.
- table_reference indicates the input to the query. It can be a regular table, a view, a join construct or a subquery.
- Simple query. For example, the following query retrieves all columns and all rows from table t1.
...