|
[广告] VBA代码宝 - VBA编程加强工具 · VBA代码随查随用 · 内置多项VBA编程加强工具 ★ 免费下载 ★ ★ 使用手册★
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.片材规格)
复制代码 |
|