On 7/31/15, Gabor Grothendieck <ggrothendieck at gmail.com> wrote: > Can we conclude, in general, that CTEs do not support > correlated subqueries? >
For a recursive CTE, the recursive table reference must occur exactly once at the top-level, never in a subquery. Other than that, there are no restrictions on the use of subqueries in SQLite's CTE implementation, at least that I recall. -- D. Richard Hipp drh at sqlite.org
