由于不清楚你的表结构的字段含义,我暂定如下,你自己在更改,本来我以为B012是库存
但它是字符型的,我就用B41替代。程序执行通过。你相应在做修改。
B001 日期
B01 商品编号
B018 入库数
B019 出库数
B41 库存
select B001,B01,sum(B018),sum(B019),
(select sum(B018)-sum(B019)+
(select B41 from Clkccopy b where b.B01=a1.B01)
from clrccopy a1 where
a1.B001<=a.B001 and a1.B01=a.B01)
from clrccopy a
group by B001,B01
select date,goods_id,sum(rks),sum(cks),
(select sum(rks)-sum(cks)/*以前多了一个)*/+(select kucun from b where b.goods_id=a1.goods_id)
from a a1 where
a1.date<=a.date and a1.goods_id=a.goods_id)
from a
group by date,goods_id
这是按日期分商品求结存数
select date,goods_id,sum(rks),sum(cks),
(select sum(rks)-sum(cks)+(select kucun from b where b.goods_id=a1.goods_id)
from a a1 where
a1.date<=a.date and a1.goods_id=a.goods_id)
from a
group by date,goods_id
你试试
select date,goods_id,sum(rks),sum(cks),
(select sum(rks)-sum(cks))+(select kucun from b where b.goods_id=a1.goods_id)
from a a1 where
a1.date<=a.date and a1.goods_id=a.goods_id)
from a//?两处FROM?
group by date,goods_id