|
[广告] Excel易用宝 - 提升Excel的操作效率 · Excel / WPS表格插件 ★ 免费下载 ★ ★ 使用帮助★
SQL语句:- select 片材规格,下片张数,领料张数,发料张数,本次结余,打样用片,本次结余-打样用片 as 实际结余 from (select A.*,B.打样用片 from (select 片材规格,sum(下片张数) as 下片张数,sum(领料张数) as 领料张数,sum(发料张数) as 发料张数,sum(本次结余) as 本次结余 from [出入库$A:G] group by 片材规格)A left join (select 片材规格,sum(发料张数) as 打样用片 from [打样用片$A:C] group by 片材规格)B on A.片材规格=B.片材规格)
复制代码
或:
- select *,本次结余-打样用片 as 实际结余 from (select A.*,B.打样用片 from (select 片材规格,sum(下片张数) as 下片张数,sum(领料张数) as 领料张数,sum(发料张数) as 发料张数,sum(本次结余) as 本次结余 from [出入库$A:G] group by 片材规格)A left join (select 片材规格,sum(发料张数) as 打样用片 from [打样用片$A:C] group by 片材规格)B on A.片材规格=B.片材规格)
复制代码 |
|