• We’re currently investigating an issue related to the forum theme and styling that is impacting page layout and visual formatting. The problem has been identified, and we are actively working on a resolution. There is no impact to user data or functionality, this is strictly a front-end display issue. We’ll post an update once the fix has been deployed. Thanks for your patience while we get this sorted.

Help with SQL query

K

Kntx

Platinum Member
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!
 
wait... Jan - Dec are the only columns in the two tables, or is there another field that identifies the record?
 
You must log in or register to reply here.

TRENDING THREADS

Back
Top