On Tue, Oct 28, 2014 at 1:50 PM, Clemens Ladisch <clem...@ladisch.de> wrote: > Joining typically involves reordering rows. You were lucky in 3.8.6. > > You have to order the result of the join before grouping: > > SELECT product_name, > GROUP_CONCAT(item_image) AS item_images > FROM (SELECT products.id AS product_id, > products.name AS product_name, > items.image AS item_image > FROM products > JOIN items ON items.product_id = products.id > ORDER BY products.id, > items.position) > GROUP BY product_id > ORDER BY product_name
That works, thank you! I always feel lucky when I get to use SQLite. ;) James _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
