sql语句问题？

CL5460

select * from
(select ID,A,B,C,T1 from table1
union
select ID,A,B,C,T2 T1 from table2
union
select ID,A,B,C,T3 T1 from table3 ) m

wersh

如果A,B,C是数字型就好办了
SELECT ID,SUM(A) A,SUM(B),SUM(C),SUM(A+B+C) TOTAL FROM
( SELECTID,A,'0' B,'0' C FROM TABLE1
UNION
SELECT ID,'0' A,B,'0' C FROM TABLE2
UNION
SELECT ID,'0' A,'0' B, C FROM TABLE3 ) M
GROUP BY ID