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

[解决办法]

delete 表1
where A in (select distinct A from 表2)
[解决办法]
delete tmpA
from 表1 as tmpA, 表2 as tmpB
where tmpA.A=tmpB.A

[解决办法]
delete from 表1 where exists(select * from 表2 wher a=表1.a)
[解决办法]
DELETE TABLE1 FROM TABLE1 INNER JOIN TABLE2 ON TABLE1.ID=TABLE2.ID
[解决办法]
delete from 表1,表2 where 表1.A = 表2.A