我有四个温度表:
我想数一下这个两个温度表
(#OneyearExpiry + #OtherYearExpiry) as A
(#ONEYRCON+#OTHERYRCON) As B
然后需要减去A-B
有人能帮我吗?
提前感谢:(
使用except
怎么样
select * from
(
select * from #OneyearExpiry
union all
select * from #OtherYearExpiry
) A
except
select * from
(
select * from #ONEYRCON
union all
select * from #OTHERYRCON
) B