On 26 Dec 2013, at 6:57pm, big stone <stonebi...@gmail.com> wrote: > "sub-select" method : > - allows you to do only a part of what you can do in CTE, > - becomes more and more difficult to read as you add tables and treatment > in your sql. > > With CTE in SQLite, it would be possible to: > - decompose your SQL treatment in clean intermediate steps, > - make your global algorithm "visible", > - do easily things currently impossible in 1 query with sub-selects.
It looks like you want VIEWs rather than sub-selects. VIEWs enable all the things you listed above. <http://www.sqlite.org/lang_createview.html> They're a way of saving a SELECT command so it can be used as if the results are a table. Simon. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
