首页 > 代码库 > 联表删除

联表删除

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