SQL: How to to SUM two values from different tables [closed]

Question

I have a number of tables with values I need to sum up. They are not linked either, but the order is the same across all the tables.

Basically, I would like to take this two tables:

CASH TABLE   London  540 France  240 Belgium 340  CHEQUE TABLE London  780 France  490 Belgium 230 

To get an output like this to feed into a graphing application:

London  1320 France  730 Belgium 570 

Answer 1

select region,sum(number) total from (     select region,number     from cash_table     union all     select region,number     from cheque_table ) t group by region 

Answer 2

SELECT (SELECT COALESCE(SUM(London), 0) FROM CASH) + (SELECT COALESCE(SUM(London), 0) FROM CHEQUE) as result 

'And so on and so forth.

"The COALESCE function basically says "return the first parameter, unless it's null in which case return the second parameter" - It's quite handy in these scenarios." Source