selectia_subsidiary.仓库编码,ia_subsidiary.存货编码,(结存数量)as明细账结存数量,isnull(iNum,0)as总帐结存数量from(SELECTcwhcodeas仓库编码,ia_subsidiary.CINVCODEas存货编码,MAX(CINVNAME)as存货名称,SUM(CASEBRDFLAGWHEN'1'THENISNULL(iainquantity,0)WHEN'0'THEN-ISNULL(IAOUTQUANTITY,0)ELSE0END)AS结存数量fromia_subsidiary,(SELECTCINVCODE,CINVNAMEFROMINVENTORY)AWHEREA.CINVCODE=ia_subsidiary.CINVCODEGROUPBYia_subsidiary.cwhcode,ia_subsidiary.CINVCODE)asia_subsidiaryjoinia_summarybonia_subsidiary.存货编码=b.cinvcodeandia_subsidiary.仓库编码=b.cwhcodeandb.imonth=(selectmax(imonth)fromia_summary)where结存数量<>iNum
