On 22 Sep 2013, at 4:06pm, James K. Lowden <jklow...@schemamania.org> wrote:
> The right answer is to join the tables in a single query and -- as you > suggest --use application logic detect when a "new" item needs a new > header. Agreed. So to summarise for the OP, the best solution is a mixture of the two that Igor and myself posted. Do the SELECT that I posted to get the right order, with the JOIN that Igor posted to get the title section from when you move from one grocery to the next. And that's why you want answers to your questions be posted to the list, folks, not directly to you. Because sometimes one reader will be able to improve on another reader's answer. Simon. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
