MYSQL中将两个查询结果合并

两个数据bai表db1,db2

查询结果A是从数据表dudb1获取的：zhi
select names, sale from db1

查询结果B是从数据表db2获取的：
select names, sale from db2

则查询结果C：

select names,sum(sale) as sale
from
(select names, sale from db1
union
select names, sale from db2
)
group by names