select all_items.itemcode, all_items.Qty, sum(all_items.sales) from
(Select itemcode, Qty, sum(sales)as sales from tn2 group by itemcode
union
Select itemcode, Qty, sum(sales) as sales from via1 group by itemcode
union
Select itemcode, Qty, sum(sales)as sales from bcg group by itemcode) all_items
group by all_items.itemcode, all_items.Qty
2条答案
按热度按时间33qvvth11#
尝试创建表的“视图”,并根据您的查询汇总值
w51jfk4q2#
可能有一个更优雅的解决方案,但这里有一个快速的方法。用并集构建三个select,然后将子查询求和。