>>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
>
>Çetin,
>
>I agree in principle, but I suspect that that can cause fields that are too narrow (if the first records happen to have null values): better replace the 0 with something like 000000.00, or with $0, depending on the field type.
Right, didn't care that. Especially if this is a view I'd take extra care to always have a fixed size value returning expressions (base table structure has changed ... thing).
Cetin