子查询可以有where语句吗?

Henry D. Sy

SELECT A.PN, A.原库存, C.进库, B.领料, B.领料报废, C.进料报废, [原库存]+Nz([进库],0)-Nz([领料],0)-Nz([领料报废],0)-Nz([进料报废],0) AS 库存
FROM ([SELECT TabWIPFS.PN, Sum(TabWIPFS.[Q-ok]) AS 原库存
FROM TabWIPFS
GROUP BY TabWIPFS.PN]. AS A LEFT JOIN [SELECT TabBaseFS.PN, Sum(TabBaseFS.[Q-OK]) AS 领料, Sum(TabBaseFS.[Q-SC]) AS 领料报废
FROM TabBaseFS
GROUP BY TabBaseFS.PN]. AS B ON A.PN = B.PN) LEFT JOIN [SELECT TabBaseFG.PN, Sum(TabBaseFG.[Q-OK]) AS 进库, Sum(TabBaseFG.[Q-SC]) AS 进料报废
FROM TabBaseFG
GROUP BY TabBaseFG.PN
]. AS C ON A.PN = C.PN;

olive_fy

版主,领料和进库那里还要加条件,where(TabBaseFS.pro="领料'),where(TabBaseFg.pro="入库'),我加条件时老是出错.
另外,好像Tabpn这个产品信息表没有用上.这个表里的产品编号是最全的,我想本月没有数据的也列出来,以0表示.

版主能不能做好样子,传上来?

不胜感激!

[ 本帖最后由 olive_fy 于 2009-1-6 16:24 编辑 ]