这是我那个语句的全部代码.
SELECT a.窑次,a.物料代码,a.一级品,a.变形,a.裂纹,a.坑洞,a.废品,a.单重,
( select sum(ff.坯数) from 装窑详情表 as ff where ff.窑次==a.窑次 and ff.物料代码 =a.物料代码 and ff.生产单号= a.生产单号 ) as 坯数,
(select (( select sum(ff.坯数) from 装窑详情表 as ff where ff.窑次==a.窑次 and ff.物料代码 =a.物料代码 and ff.生产单号= a.生产单号 ) as 坯数) * a.单重) as 窑重,
( select sum(bb.一级品) from 包装自检记录单 as bb where bb.窑次==a.窑次 and bb.物料代码 =a.物料代码 ) as 一级品累计,
( select sum(cc.变形) from 包装自检记录单 as cc where cc.窑次==a.窑次 and cc.物料代码 =a.物料代码 ) as 变形累计,
( select sum(dd.裂纹) from 包装自检记录单 as dd where dd.窑次==a.窑次 and dd.物料代码 =a.物料代码 ) as 裂纹累计,
( select sum(ee.坑洞) from 包装自检记录单 as ee where ee.窑次==a.窑次 and ee.物料代码 =a.物料代码 ) as 坑洞累计,
( select sum(bb.废品) from 包装自检记录单 as bb where bb.窑次==a.窑次 and bb.物料代码 =a.物料代码 ) as 废品累计
FROM 包装自检记录单 as a group by 窑次,物料代码
我想实现的目的是 想要这一窑次的总累计
|
