delete from table1 where table1.column1 IN (SELECT column2 FROM table2 WHERE column3 = 'XXXXXXXXX') //table1的column1的值等于table2的column2的值
