记录删除(简单问题，先解决者有分)

[xyz_no1]

有两个表table1,table2,他们有相同的两个字段field1,field2
现在要从table1中删除这样的记录：该记录字段field1,field2的值
对应于table2中的某记录（即table1.field1=table2.field1 and table1.field2=table2.field2）
请大家帮忙

[zgamer]

在select语句中可以用的条件，在delete中不是可以照样用吗

[tikkypeng]

delete table1 where table1.field1=table2.field1 and table1.field2=table2.field2

[xyz_no1]

MountLion(人不寐)的方法正确

[suary]

如果是用SQL SERVER 数据库可写触发器

[windindance]

delete table1 where table1.field1=table2.field1 and table1.field2=table2.field2

[xyz_no1]

这样写的话，认不到table2.field1,table2.field2

[xyz_no1]

知道的话，请帮忙

[MountLion]

delete from table1 a
where exists(select * from table2 b where a.field1=b.field1 and a.field2=b.field2)

[yqh]

delete from (select * from table1 a,table2 b where a.field1=b.field1 and a.field2=b.field2)