跨表SQL

[擒兽]

两张表A和B

查询B里面当中一个字段的内容在A里面当中一个字段内没有匹配的记录

两张表都有若干记录，B是主要数据表 A里面的数据量很少。


求一句SQL

[hsj20041004]

查询B里面当中字段COL1的内容在A里面当中字段COL1内没有匹配的记录

select * from B where not exists (select * from A where A.col1=B.col1)
OR:
select * from B where col1 not in (select col1 from A )

[pbsql]

select * from B where not exists(select * from A where A.字段=B.字段)

[点点星灯]

select * from B where b.ziduan1 not in(select ziduan2 from A)

[lichunlei2003]

select B.b from B where B.b not in(select A.a from A)

[wwwwb]

select * from B where keyfield not in(select keyfield from A )

[Yisa]

同意樓上的.