Hi,

I'm running a query which sums up transactions by accounts.

Some accounts dont have ANY transactions and thus a NULL is found in the
BALANCE field and some accounts have a figure. How can I make the NULL
0.00 instead of NULL ?

Thanks,
Phil.

It's OK I found...

COALESCE(SUM(trans.trans_total), 0.00) AS balance