delete from table1 where table1.column1 IN (SELECT column2 FROM table2 WHERE column3 = ‘XXXXXXXXX‘) //table1的column1的值等于table2的column2的值
联表删除,布布扣,bubuko.com
联表删除
原文：http://www.cnblogs.com/kangjing/p/3927447.html
