This option enables the FROM clause of the recursive statement to specify the name of the RECURSIVE query and one or more single table references, creating an implicit inner join.
query_name_specifier
- query_name
- Named query referred to in the FROM clause.
- correlation_name_2
- Alias for the query name referenced in the FROM clause.
- table_name
- Name of a single table or view referred to in the FROM clause.
- correlation_name_1
- Alias for the table name referenced in the FROM clause.