Question

mysql查询结果重复合并

select province.name,city.name1,area.name2 from city left join province on city.provincecode=province.code left join area on area.citycode=city.code
查询的结果

怎么变成
name name1 name2
北京 北京 东城区，西城区，崇文区，宣武区

请高手解答！！！！！！！！！

Answer 1

用group_concat
select name,name1,group_concat(name2) from (select province.name as name,city.name1 as name1,area.name2 as name2 from city left join province on city.provincecode=province.code left join area on area.citycode=city.code) group by name,name1;