I have two queries like:
SELECT SUM(DB) FROM Table1 WHERE Date1 Between '20110101' and '20111231'
SELECT SUM(PMBelop) FROM Table2 WHERE Date2 Between '20110101' and '20111231'
How can i sum both with one output?
SELECT (query 1) + (Query 2) but the result are wrong if one of the queries returns <NULL> then the output also are <null>