两个相同结果集求差值问题

[zblaoshu1979]

两个相同的结果集：（id1和id2联合主键）
结果集一：
id1 id2 name
1 1 aaa
1 2 bbb
2 1 dfsd
2 2 uefue
2 3 kjkk
结果集二：
id1 id2 name
1 1 aaa
2 1 dfsd

得到这样结果:
id1 id2 name
1 2 bbb
2 2 uefue
2 3 kjkk

[常飞梦]

select t1.id1,t1.id2,t1.name from t1 left join t2 on t1.id1=t2.id1 and t1.id2=t2.id2
where t2.id1 is null

[churchatp1]

select *
from 结果集1 a
where not exists(select * from 结果集2 b where a.id1=b.id1 and a.id2=b.id2)

[OracleRoob]

select A.*
from 结果集1 A left join 结果集2 B on A.id1 = B.id1 and A.id2 = B.id2
where B.id1 is null

[liuyulei]

select a.id1,a.id2,a.name from a left join b
on a.id1=b.id1 and a.id2=b.id2
where b.id1 is null and b.id2 is null

[liuyulei]

select * from a
where name not in(select name from b )

[hglhyy]

select *
from 结果集1 a
where not exists(select * from 结果集2 b where a.id1=b.id1 and a.id2=b.id2)

UP

[常飞梦]

mark