On 13 Nov 2011, at 1:47am, Alexandre Courbot wrote: > On Sat, Nov 12, 2011 at 11:59 PM, Black, Michael (IS) > <michael.bla...@ngc.com> wrote: >> Why are you contorting yourself into just one query? > > It is actually part of a larger query that joins against this result. > Granted, there are ways to workaround this, but I would be surprised > if it was not possible to express that in SQL so wanted to ask the > community about this.
Sometimes it's possible, with many joins and aggregations, to express a query as one query in SQL, but it's faster to split it into three, sometimes parsing the result using a programming language, sometimes creating a temporary table to put the results into for searching. Simon. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
