求一条SQL语句 ( 积分: 50 )

A

aszou

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2007-07-29

• #1

Access数据库，
A表：ID，...
B表：ID，...
准备删除B中ID不在A表中的记录
下面的语句效率太低：

delete from b
where b.id not in(select a.id from a)

 

S

suger

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2007-07-29

• #2

delete b
from b b
where not Exists(select * from a where ID = b.ID)

这样看看速度如何!呵呵。

 

A

aszou

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2007-07-29

• #3

to suger:
真的很灵，非常感谢，结贴！

 

A

aszou

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2007-07-29

• #4

送分！