594
社区成员
发帖
与我相关
我的任务
分享
select
area,subarea,sum(price) AS price
from (select * from table1
union all
select * from table2
union all
select * from table3
union all
select * from table4
) as t
group by area,subarea
select area,subarea,sum(price) from 新表 group by area,subarea