如何将表1中字段A值等于表2中字段A的记录删除？

[jjdown]

表1的字段A和表2的字段A的结构是一直的，如何将表1中字段A值等于表2中字段A的记录删除？

[marco08]

delete 表1
where A in (select distinct A from 表2)

[marco08]

delete tmpA
from 表1 as tmpA, 表2 as tmpB
where tmpA.A=tmpB.A

[cxmcxm]

delete from 表1 where exists(select * from 表2 wher a=表1.a)

[pengxuan]

DELETE TABLE1 FROM TABLE1 INNER JOIN TABLE2 ON TABLE1.ID=TABLE2.ID

[dawugui]

delete from 表1,表2 where 表1.A = 表2.A