oracle多表查询，求救，在线等待！！！

[liangyiqing]

有两个表，表结构一模一样的两个表，都有两个字段name,card_id，里面数据不同，我想删除其中一个表中的(另外一个表里也有的相同的)数据，该怎么办？也就是说如果A表和B表中都有m这条数据，我需要把A表中的m数据删除，该怎么办？

[podded]

delete a where exists
(select * from a,b where a.name=b.name and a.card_id=b.card_id);

[podded]

或者
delete a where a.name in
(select a.name from a,b where a.name=b.name and a.card_id=b.card_id);

[fuhai]

delete from A where where A.name=B.name and A.card_id=B.card_id

[liangyiqing]

to fuhai(海之魂):
delete from A where A.name=B.name and A.card_id=B.card_id
这个语句在oracle里面执行不了！

to podded(阿朱)：
delete a where a.name in
(select a.name from a,b where a.name=b.name and a.card_id=b.card_id);
这个语句中，如果name字段值不是唯一的，就会误删很多name一样，但card_id不一样的值

[sanoul]

delete from A where rowid in (select rowid from A,B where A.name=B.name and A.card_id=B.card_id)

[sanoul]

delete from A where rowid in (select A.rowid from A,B where A.name=B.name and A.card_id=B.card_id)

[liangyiqing]

非常感谢 sanoul(垃圾) ，非常感谢！！！