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 ...