SELECT sum(rds.iQuantity) as iQuantity,sum(rds.iMoney) as iMoney,
--sum(rds.iMoney)/sum(rds.iQuantity) as iUnitCost,
BA_Inventory.cInvCode,BA_Inventory.UFcInvCode,BA_Inventory.cInvStd,BA_Inventory.cInvName,BA_Inventory.cComUnit
FROM RdRecords rds
INNER JOIN RdRecord rdr ON rds.[ID]=rdr.[ID]
INNER JOIN BA_WareHouse ON rdr.cWhCode=BA_WareHouse.cWhCode
INNER JOIN BA_Inventory ON rds.cInvCode=BA_Inventory.cInvCode
WHERE iDate>='2010-5-1' AND iDate<='2010-5-31'
AND CAST(iQuantity AS FLOAT)<>0 --这里的过滤条件问题
GROUP BY BA_Inventory.cInvCode,BA_Inventory.UFcInvCode,BA_Inventory.cInvStd,BA_Inventory.cInvName,BA_Inventory.cComUnit
ORDER BY iquantity ASC
这样查询出来的iQuantity 字段有零,sum(rds.iMoney)/sum(rds.iQuantity) as iUnitCost这个计算就报错,我想把为零的过滤掉,AND CAST(iQuantity AS FLOAT)<>0,这个条件不起作用呢?