On 3 Jan 2012, at 5:50pm, Kit wrote: > 2012/1/3 Simon Slavin <slav...@bigfraud.org>: >> SELECT id,group_concat(type) FROM (SELECT ID, prdtype FROM prds ORDER BY id, >> prdtype); >> Simon. > > SELECT id,group_concat(prdtype) FROM (SELECT ID, prdtype FROM prds > ORDER BY id, prdtype) GROUP BY id;
Thanks. I forgot that bit. Simon. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
