|
Table_reference
|
|
|---|---|
|
table_reference_list
|
::= table reference [ , table-reference ... ]
|
|
tablepreference
|
::= 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 ] |
|
joinjtype
|
::= 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 } ...] |