Recursive Statement
The recursive statement is a SELECT statement that retrieves row data from a join of the named query and other tables.
You cannot include NORMALIZE in a recursive statement of a recursive query.
Syntax Element … |
Specifies … |
* |
that all columns of all tables referenced in the FROM clause of the recursive statement be returned. When qualified by table_name, specifies that all columns of table_name only are to be returned. |
expression |
any valid SQL expression, with these exceptions: |
AS |
an optional introduction to expression_alias_name. |
expression_alias_name |
an alias for the expression. |
table_name |
the name of the named query or the name of a table or view. table_name.* in the select list can define the table from which rows are to be returned when two or more tables are referenced in the FROM clause. |
FROM |
an introduction to the named query and one or more tables or views from which expression is to be derived. The FROM clause in a recursive statement cannot specify the TABLE option. |