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:
CODE --> sql
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!