减的话,这样实现: select sum(fa) from ( select sum(num1) as fa from table1 union select sum(num2) as fa from table2 union select sum(num3) as fa from table3 union select 0-sum(num4) as fa from table4 union select 0-sum(num5) as fa from table5 ) as tmp ===================================== ===================================== 方法多种,先给一种: select sum(fa) from ( select sum(num1) as fa from table1 union select sum(num2) as fa from table2 union ... union select sum(numn) as fa from tablen ) as tmp