Require Urgent Help Regarding UNION and SUM

[maddysanoo]

Hello Everyone,
Hope you all are doing good?
Here is the scenario:

1. Table Structure: Have 3 tables:
JAN2010
FEB2010
MAR2010

All of the tables have the following fields:
CIS
Segments
NET_PROFITABILITY

Following is the data:

JAN2010
CIS Segments NET_PROFITABILITY
1005145 Extended 34
3245677 EEU 33
45454 Basic 22

FEB2010
CIS Segments NET_PROFITABILITY


45454 Basic 12
3245677 EEU 3
1005145 Extended 4

FEB2010
CIS Segments NET_PROFITABILITY
3245677 EEU 3
45454 Basic 2
1005145 Extended 5


2. What needs to be done:

What i need to do is to have NET_PROFITABLITY added for all te three months and have respective Segments displayed along with their CIS.

Please let me know about this. Need your help. I know it will be done using UNION AND SUM but not sure how.

Please please please let me know.

Regards,

Maddy

[pbaldy]

For starters, you realize that's a big design flaw? The UNION query will simply be used to get the data into the format it should have been in in the first place.

SELECT CIS, Segments, NET_PROFITABILITY, "201001" AS Period
FROM Jan2010
UNION ALL
SELECT CIS, Segments, NET_PROFITABILITY, "201002" AS Period
FROM Feb2010
...

Then a totals query against that.