mysql查询结果重复合并

用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

select name,sum(count)

from(

select name, count

from A

union all

select name, count

from B

)

group by name

说明：将两表的查询结果进行不去重复结合，作为新表查询，按照name分组求和。

---