My query is here select abstracts_item._id,abstract_author.name, title,affiliation_number,af_name from
abs_affiliation_name,abstract_affiliation, abstracts_item,abstract_author,authors_abstract where abstracts_item._id = authors_abstract.abstractsitem_id and abstract_author._id = authors_abstract.abstractauthor_id and abstract_affiliation._id = abstract_author._id and abs_affiliation_name._id = abstracts_item._id After running the query I got data like this one ID - NAME - TITLE - AFNUMBER - AFNAME 1 - A - AB - 1,2 - CD 1 - B - AB - 1,2 - CD 2 - C - BC - 2,3 - VB 2 - D - BC - 2,3 - VB I want to get data like this ID - NAME - TITLE - AFNUMBER - AFNAME 1 - A,B - AB - 1,2 - CD 2 - C,D - BC - 2,3 - VB I am try with this SELECT _id,GROUP_CONCAT(TITLE) FROM(select abstracts_item._id,abstract_author.name, title, type, topic, text,affiliation_number,af_name from abs_affiliation_name,abstract_affiliation,abstracts_item,abstract_author,authors_abstract where abstracts_item._id = authors_abstract.abstractsitem_id and abstract_author._id = authors_abstract.abstractauthor_id and abstract_affiliation._id = abstract_author._id and abs_affiliation_name._id = abstracts_item._id Order by abstracts_item._id,abstracts_item.title,abstract_author.name ) GROUP by _id,TITLE But, it's not showing the correct data. -- View this message in context: http://sqlite.1065341.n5.nabble.com/SQLite-group-concat-multiple-columns-format-tp70375.html Sent from the SQLite mailing list archive at Nabble.com. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
