很简单,你按照下面结构写一下就行了,关键在union all的使用,这个对于计划、财务、库存都能使用,希望能帮到你。select 产品,sum(预测量) as 汇总预测量,sum(开工量) as 汇总开工量, sum(期末量) as 汇总期末量from (select 商品,数量 as 预测量,0 as 开工量,数量 as 期末量 from 预测表 union allselect 商品,0 as 预测量,数量 as 开工量,数量*-1 as 期末量 from 开工表) as 汇总表 group by 产品...
|