On Fri, Nov 14, 2014 at 6:16 PM, Paul Sanderson < sandersonforens...@gmail.com> wrote:
> I can simplify the SQL by creating a view andthen use the ciew in my > recursive cte, but for various reasons I would rather not do this. > > Is it possible to use a recursive cte that refers to a cte? > http://www.sqlite.org/lang_with.html You can combine several CTEs into one big SELECT, which seems to be what you're asking? Search that page for "mandelbrot" for an extreme example. -- ----- stephan beal http://wanderinghorse.net/home/stephan/ http://gplus.to/sgbeal "Freedom is sloppy. But since tyranny's the only guaranteed byproduct of those who insist on a perfect world, freedom will have to do." -- Bigby Wolf _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users