SQL Guide : solidDB® SQL statements : Common clauses : table_reference
  
table_reference
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 } ...]
See also
Common clauses