Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
Author |
Topic |
taj
Starting Member
39 Posts |
Posted - 2013-09-16 : 08:02:14
|
HI ALL I HAVE 30 DIFFERENT TABLES, IN ALL 30 TABLES I HAVE FOUR COMMON COLUMNSA,B,C,D. Now I WANNA JOINS ALL 30 TABLES AND MAKE THE SUM OF (A),SUM OF(B),SUM OF (C),SUM OF(D).How to do this?Thank You |
|
khtan
In (Som, Ni, Yak)
17689 Posts |
Posted - 2013-09-16 : 08:20:29
|
[code]SELECT SUM(A), SUM(B), SUM(C), SUM(D)FROM ( SELECT A, B, C, D FROM TABLE1 UNION ALL SELECT A, B, C, D FROM TABLE2 UNION ALL SELECT A, B, C, D FROM TABLE3 UNION ALL . . . ) d[/code] KH[spoiler]Time is always against us[/spoiler] |
|
|
|
|
|
|
|