删除B表中的数据:

 

先假设A.A1 = B.B1 = D.D1,B.B2 = C.C2
1.删除B表中的数据:
DELETE FROM B WHERE B1 IN (SELECT A1 FROM A WHERE (此处加上A表的过滤条件)) ;
2.删除C表中的数据
DELETE FROM C WHERE C2 IN (SELECT B2 FROM B WHERE B1 IN (SELECT A1 FROM A WHERE (此处加上A表的过滤条件))) ;
3.删除D表中的数据
DELETE FROM D WHERE D1 IN (SELECT A1 FROM A WHERE (此处加上A表的过滤条件)) ;

---

修罗王 [等级：◆◆(初级)] (信誉值: 100) 回复于: 2005-7-14 16:54:30 Top

补充一点,应该先删除D表的数据,然后C,然后B最后才A,不然就会出现找不到数据的问题