删除两个表中字段一样的记录 delete from xl11 where dhhm in(SELECT a.dhhm FROM xl11 AS a, xl919 AS b WHERE a.dhhm=b.dhhm;);