先假设A.A1 = B.B1 = D.D1,B.B2 = C.C21.删除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,不然就会出现找不到数据的问题
