select
fcity,sum(fbicetd) as fbicetd
from
(select fcity,fbicetd from tb1 where 日期筛选
union all
select pname as fcity,pmoney as fbicetd from tb2 where 日期筛选)t
group by
fcity
order by
2
select
fcity,sum(fbicetd) as fbicetd
from
(select fcity,fbicetd from tb1
union all
select pname as fcity,pmoney as fbicetd from tb2)t
group by
fcity
order by
2