Help with SQL query

[Kntx]

Ok, so here's what I have.

2 Tables with columns... Jan, Feb, Mar, Apr... etc.

I want to sum the columns of each table with the sum of the colums of the other table. In the end I would like to return one row which is the totals for each month.

This sort of illustrates what I would like to be able to do with each column...

sum(select Jan from Table1 union select Jan from Table2)

Thanx for any help!

 

[mugs]

wait... Jan - Dec are the only columns in the two tables, or is there another field that identifies the record?