It seems that it is not possible to specify the concatenation separator when using GROUP_CONCAT with DISTINCT.
For example while this works SELECT pub_id, GROUP_CONCAT(cate_id, " - ") FROM book_mast GROUP BY pub_id; and this works SELECT pub_id, GROUP_CONCAT(DISTINCT cate_id) FROM book_mast GROUP BY pub_id; this does not SELECT pub_id, GROUP_CONCAT(DISTINCT cate_id, " - ") FROM book_mast GROUP BY pub_id; Is that an error, or by design? Is there another way I can specify the separator when using DISTINCT? _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users