table‑reference
The table‑reference clause has the following syntax:
table‑reference‑list::= table‑reference [{, table‑reference} …]
table‑reference::= table‑name [[AS] correlation‑name ] |
derived‑table [[AS] correlation‑name [(derived‑column‑list)]] | joined‑table
table‑name::= table‑identifier | schema‑name.table‑identifier
derived‑table::= subquery
derived‑column‑list::= column‑name‑list
joined‑table::= cross‑join | qualified‑join | (joined‑table)
cross‑join::= table‑reference CROSS JOIN table‑reference
qualified‑join::= table‑reference [NATURAL] [join‑type]
JOIN table‑reference [join‑specification]
join‑type::= INNER | outer‑join‑type [OUTER] | UNION
outer‑join‑type::= LEFT | RIGHT | FULL
join‑specification::= join‑condition | named‑columns‑join
join‑condition::= ON search‑condition
named‑columns‑join::= USING (column‑name‑list)
column‑name‑list::= column‑identifier [{, column_identifier} …]
Go up to