sum of two Queries
i acn use
select a,b,c from ABC
unoin
select a,b,c from DEF
is there any method other than following. to ADD values of above queries
ie 1ineed output in a+a,b+b,c+c
iget result by
select sum(t.a),sum(t.b),sum(t.c) from(select a,b,c from ABC
unoin
select 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???