Set hzhadd = conn.Execute("select  sum(jnum) from bonus_points b where     b.ptype=3  and b.jgrade='2013' and b.jclass='1'  ")
Set hzhdec = conn.Execute("select  sum(knum)*-1  from bonus_points b where     b.ptype=1  and b.kgrade='2013' and b.kclass='1'  ")



请问如何合并成一句话.>?

union还是加和？

加和

select sum(s) from (select sum(col1)s from table1
union select sum(col2)s from table2) a