有2个表 a 和 b

里面都有id这个列名

我想把b表里面的id和a表里面的id比较了后,删除掉a表里面相同的id..请教sql命令是什么...


谢谢了!!!!急!在线等!!!!!!!!!!!!高手指点!!!!!!!


我用的是sql2000

[此贴子已经被作者于2005-12-22 15:49:37编辑过]

期待大家的帮助。.....

我也是才学,你看下行不:delete from a where id in (selete id from a,b where a.id=b.id)

恩恩。对的。就是这个...

不过我是这么用的

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

delete from a where id in (selete id from a,b where a.id=b.id)

还是你自己水平高啊！
delete from a where id in (select id from b)

Delete A where id in(select id from B);

delete from a where id in (select id from b)
这个最好