I used "Blahs" just for this example: One of these queries will sometimes be zero (No payments that day to add) which makes it NULL so even though the second query will have a valid SUM the whole query will add up to NULL just because the first query added up to zero. Is there any way to make the first query to say 0 instead of null so it'll properly add the totals? 1st query adds up to zero and second query adds up to 100. I want it to say  0 + 100 = 100. Right now its saying: Null + 100 = NULL. Thanks
 SELECT (Select  SUM Go to the complete details ...

Found interesting? Add this to: