SELECT t3.FShortNumber AS ''''物料代码'''',
t3.FName AS ''''物料名称'''',
t3.FModel AS ''''规格型号'''',
t4.FName AS ''''单位'''',
SUM(CASE WHEN t1.FTranType in (1,2,5,10,40) THEN t2.FQty ELSE 0 END) AS ''''''''''''''''收入数量'''''''''''''''',
SUM(CASE WHEN t1.FTranType in (24,28,29,21,43) and t5.FDeptID in (733) THEN t2.FQty ELSE 0 END) AS ''''A厂'''',
SUM(CASE WHEN t1.FTranType in (24,28,29,21,43) and t5.FDeptID in (736) THEN t2.FQty ELSE 0 END) AS ''''B厂'''',
SUM(CASE WHEN t1.FTranType in (24,28,29,21,43) and t5.FDeptID in (737) THEN t2.FQty ELSE 0 END) AS ''''C厂'''',
SUM(CASE WHEN t1.FTranType in (24,28,29,21,43) and t5.FDeptID in (738) THEN t2.FQty ELSE 0 END) AS ''''D厂'''',
SUM(CASE WHEN t1.FTranType in (24,28,29,21,43) and t5.FDeptID in (739) THEN t2.FQty ELSE 0 END) AS ''''E厂'''',
SUM(CASE WHEN t1.FTranType in (24,28,29,21,43) and t5.FDeptID in (740) THEN t2.FQty ELSE 0 END) AS ''''F厂'''',
SUM(CASE WHEN t1.FTranType in (24,28,29,21,43) and t5.FDeptID in (897) THEN t2.FQty ELSE 0 END) AS ''''G厂'''',
SUM(CASE WHEN t1.FTranType in (24,28,29,21,43) THEN t2.FQty ELSE 0 END) AS ''''发出数量'''',
t3.FQtyDecimal AS ''''数量精度'''',
t3.FPriceDecimal AS ''''单价精度''''
FROM ICStockBill t1,ICStockBillEntry t2,t_ICItem t3,t_MeasureUnit t4,ICStockBill t5
WHERE t1.FInterID=t2.FInterID
AND t2.FInterID=t5.FInterID
AND t2.FItemID=t3.FItemID
AND t4.FItemID=t3.FUnitID
AND t1.FDate>=''''********''''
and t1.FDate<=''''########''''
AND t4.FStandard=1
Group By t3.FItemID,t3.FShortNumber,t3.FName,t3.FModel,t4.FName,t3.FQtyDecimal,t3.FPriceDecimal

如何在这段代码里面加上期初结存与期末结存数量?
期初与期末是动态的,会随着会计其间变化而变化,

我有试过在ICBal与ICInvBal里取字段,但取数后,查询的结果是错的,
如果直接取字段,行不行?
它们与以上字段应该用什么样的条件来连起来?
请帮忙!!!


-----
此帖被flint428921于2005-1-15 15:24:23修改过.

-----
此帖被flint428921于2005-1-15 15:24:31修改过.

-----
此帖被flint428921于2005-1-15 15:28:13修改过. ----- 此帖被flint428921于2005-1-15 15:31:54修改过.