当table2.field1为主键或唯一索引的时候,可以这么写: DELETE Table1.* FROM Table1 INNER JOIN Table2 ON Table1.FIELD1 = Table2.FIELD1; 其他情况下不行