null value 1

[ksbrace]

Hello,
I'm getting null values for paymentamout when it should be 0 and I would like to populate the nulls with a zero. I thought this would do it:

select sum(p.paymentamount), pf.portfolio, pf.placementdate 
from portfolios pf left outer join payments p on p.portfolio=pf.portfolio 
and p.paymentstatus='PENDING' 
group by pf.portfolio order by pf.placementdate;

Any help would be great!

 

[IanWaterman]

try

select sum(ifnull(p.paymentamount,0)), ......

Ian