sum of two Queriesi acn use select a,b,c from ABCunoinselect a,b,c from DEF
is there any method other than following. to ADD values of above queriesie 1ineed output in a+a,b+b,c+ciget result by
select sum(t.a),sum(t.b),sum(t.c) from(select a,b,c from ABCunoinselect a,b,c from DEF)as t
and select a+(select a from DEF),b+(select b from DEF),c+(select c from DEF) from ABC
above two gives result but in my case its not correct help me pls???