如何查询出A表中不存在于B中的记录

[abitoom]

假设:
A表: B表:
A1字段 A2字段 B1字段 B2字段
1 11 1 55
2 22 4 66
3 33 7 999

如何查询出A表中不存在于B中的记录，也就是记录
2 22
3 33

但是，不能与B表组合，我只需要A表的记录，不需要B表的东西。

[kuaile14]

select * from A
where A1 in (select A1 from A minus select B1 from B)

[hsj20041004]

select * from A
where A1 not in ( select B1 from B)

[bluecocoqd]

select * from A where A1 not in (select B1 from B where B1 is not null)

select * from A where A1 where not exists (select 1 from B where A1=B1)

select * from A
where A1 in (select A1 from A minus select B1 from B)

用minus、not in、not exists都可以实现

[heyixiang]

如果表的数据量大的话就不要用not in

用not exists 和 outer join where b.bi is null

[hanxingwuqing]

select * from A where A1 where not exists (select B1 from B where A1=B1)

[xojxau]

select * from A where a.a1||a.a2 not in(select b.b1||b.b2 from b)