Implicit Join
This option enables the FROM clause of the recursive statement to specify the name of the WITH RECURSIVE query and one or more single table references, creating an implicit inner join.
|
Syntax Element … |
Specifies … |
|
query_name |
the named query referred to in the FROM clause. |
|
AS |
an optional introduction to correlation_name. |
|
correlation_name |
an alias for the query name referenced in the FROM clause. |
|
table_name |
the name of a single table or view referred to in the FROM clause. |
|
AS |
an optional introduction to correlation_name. |
|
correlation_name |
an alias for the table name referenced in the FROM clause. |