-- 没有测试,你自己改改吧。
create table a(id int , value int )
create table b(id int , value int )insert into a values(1,1)
insert into a values(2,2)
insert into a values(3,3)insert into b values(1,1)
insert into b values(2,3)select id , value
from (
select id,value from a
union all
select id,value from b
)
group by id , value
having COUNT(*) = 1
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货