>Dear Cetin,
>
>Thanks for your response.
>Here's my code:
>
>SELECT Stockbook.ddate,Stockbook.citemname, Stockbook.citemid, Stockbook.nqtyin,;
> Stockbook.ncost, SUM(Stockout.nqtyout)-SUM(Stockout.nqtyret) AS qtyout ,;
> (Stockbook.nqtyin-sum(stockbook.nqtydel))-(SUM(Stockout.nqtyout)-SUM(Stockout.nqtyret)) AS avlbal;
> FROM stockbook LEFT OUTER JOIN stockout ;
> ON Stockbook.citemid = Stockout.citemid;
> WHERE Stockbook.citemname = lcitemname;
> GROUP BY Stockbook.citemid;
> ORDER BY Stockbook.citemid;
> INTO CURSOR curAvlStock
>
>...and the error message I get:
>
>'Field QTYOUT does not accept null values'
>
>Thanks Cetin,
>
>Regards,
>
>Steve.
When 2nd table has no matching records returned value is null causing sum() to be null. Check 'set null'. Also you can change your expressions to handle nulls. ie :
instead of :
SUM(Stockout.nqtyout)-SUM(Stockout.nqtyret) AS qtyout
try :
SUM( nvl(Stockout.nqtyout,0)-nvl(Stockout.nqtyret,0) ) AS qtyout
Cetin