MYSQL一对多,两表查询合并数据

select a.askid,a.title,GROUP_CONCAT(b.message SEPARATOR '----') as content from gg_ask as a join gg_ask_posts as b
on a.askid=b.askid GROUP BY a.askid;

原文地址:https://www.cnblogs.com/linuxOS/p/4423958.html