Login
Products
Sales
Support
Downloads
About
Home
»
Technical Support
»
ElevateDB Technical Support
»
Support Forums
»
ElevateDB SQL
»
View Thread
View Thread
The following is the text of the current message along with any replies.
Messages 1 to 2 of 2 total
NULL and amounts
Wed, Jun 20 2012 9:18 PM
Permanent Link
IQA
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.
Wed, Jun 20 2012 9:47 PM
Permanent Link
IQA
It's OK I found...
COALESCE(SUM(trans.trans_total), 0.00) AS balance