两个数据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
SpringJson 2020-09-18 15:54 原文
两个数据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