是这样的:我想让“入库数量”减“出库数量”等于现在的库存,下面的查询语句没有出错,但是执行查询的结果不正确。请大家给我看看,其中ruku,chuku代表入库和出库表,spshuliang代表商品数量,spid代表商品编号。我用的是ACCESS数据库。
select ruku.spid,sum(ruku.spshuliang)-sum(chuku.spshuliang) as 库存商品数量 from chuku,ruku where ruku.spid=chuku.spid group by ruku.spid,chuku.spid order by ruku.spid谢谢大家。
select ruku.spid,sum(ruku.spshuliang)-sum(chuku.spshuliang) as 库存商品数量 from chuku,ruku where ruku.spid=chuku.spid group by ruku.spid,chuku.spid order by ruku.spid谢谢大家。
再试试
其实你可以用程序写的啊,这样不但减轻服务器的负担,而且更加具有灵活性啊再不行用存储过程写
ACCESS支持“*=”吗?
:)
from ruku left join chuku on ruku.spid = chuku.spid
group by ruku.spid, chuku.spid order by ruku.spid
from
(select spid, sum(spshuliang) as spshuliang1 from ruku group by spid) as a
left join
(select spid, sum(spshuliang) as spshuliang1 from chuku group by spid) as b
on a.spid = b.spid
order by a.spid
(select spid,sum(spshuliang) as spshuliang from ruku group by spid) as a
left outer join
(select spid,sum(spshuliang) as spshuliang from chuku group by spid) as b
on a.spid=b.spid