ASA SQL User's Guide
  Query Optimization and Execution
    Query execution algorithms
      Accessing tables

Recursive table

A recursive table is a common table expression constructed as a result of a WITH clause in a query. The WITH clause is used for recursive union queries. Common table expressions are temporary views that are known only within the scope of a single SELECT statement.

For more information, see Common Table Expressions.