A FROM clause can include a sequence of single table references.
This action creates an implicit inner join, instead of explicit joins where the keyword JOIN is part of the syntax.
|
Syntax Element … |
Specifies … |
|
table_name |
the name of a base table, queue table, global temporary table, volatile table, derived table, or view. If the database is omitted, the system infers it from context. |
|
AS |
an optional introduction to correlation_name. |
|
correlation_name |
an optional alias for the table that is referenced by table_name. Note that you must specify a correlation_name for a self-join. ANSI SQL refers to table aliases as correlation names. Correlation names are also referred to as range variables. |