with-clause-recursive-restrictions.md
The following restrictions apply:
-
The SELECT list of a non-recursive term cannot include the wildcard
*(asterisk) or the function MATCH_COLUMNS. -
A recursive term can reference the target CTE only once.
-
Recursive reference cannot appear within an outer join.
-
Recursive reference cannot appear within a subquery.
-
WITH clauses do not support UNION options ORDER BY, LIMIT, and OFFSET.