请教,SQL语句：查询A表中字段a,b在B表中字段a,b没有出现的所有记录！

[dezwen]

请教,SQL语句：查询A表中字段a,b在B表中字段a,b没有出现的所有记录！

表A
a | b | c
1 1 1
1 2 2
2 1 3

表B
a | b | c
1 1 1
1 2 2

我想得到的结果是：
a | b | c
2 1 3

[sdxiong]

select a.*
from 表A a
left join 表B b on a.a=b.a and a.b=b.b
where b.a is null

[hery2002]

-->生成测试数据
 
declare @A table([a] int,[b] int,[c] int)
Insert @A
select 1,1,1 union all
select 1,2,2 union all
select 2,1,3
--Select * from @A

declare @B table([a] int,[b] int,[c] int)
Insert @B
select 1,1,1 union all
select 1,2,2
--Select * from @B

select * from @a a
where not exists (select 1 from @b where [a] = a.[a] and [b] = a.[b])
/*
a           b           c
----------- ----------- -----------
2           1           3

*/

[中国风]

select * from a where checksum(a,b) not in(select checksum(a,b) from b )

[lb6201883]

create table A(a int ,b int, c int)



create table B(a int ,b int, c int)

insert A
select 1,1,1 union all
select 1,2,2 union all
select 2,1,3

insert B
select 1,1,1 union all
select 1,2,2

select * from A where not exists(select 1 from B where a=A.a and b=A.b)

[lifeiping]

http://topic.csdn.net/u/20080626/00/43d0d10c-28f1-418d-a05b-663880da278a.html

[水族杰纶]

[Quote=引用 2 楼 hery2002 的回复:]
SQL code-->生成测试数据

declare @A table([a] int,[b] int,[c] int)
Insert @A
select 1,1,1 union all
select 1,2,2 union all
select 2,1,3
--Select * from @A

declare @B table([a] int,[b] int,[c] int)
Insert @B
select 1,1,1 union all
select 1,2,2
--Select * from @B

select * from @a a
where not exists (select 1 from @b where [a] = a.[a] and [b] = a.[b])
/*
a b …
[/Quote]

[hyqwan11112]

[Quote=引用 3 楼 roy_88 的回复:]
SQL codeselect*fromawherechecksum(a,b)notin(selectchecksum(a,b)fromb )
[/Quote]