Oracle 多表关联删除,不支持下面的JOIN关联语法
DELETE FROM TAM_GROUPS_MEMBERS M
JOIN TAM_ABSMEMBER A1 ON M.N_GM_MEMBER_ID=A1.N_ABSMEMBER_ID
JOIN TAM_ABSMEMBER A2 ON M.N_GM_GROUP_ID=A2.N_ABSMEMBER_ID
WHERE A1.C_NAME= ? OR A2.C_NAME= ?;
对于删除或更新多表关联,可以使用EXISTS语句改写上面的SQL
DELETE FROM TAM_GROUPS_MEMBERS M
WHERE EXISTS (SELECT * FROM TAM_ABSMEMBER A1, TAM_ABSMEMBER A2
WHERE M.N_GM_MEMBER_ID=A1.N_ABSMEMBER_ID AND M.N_GM_GROUP_ID=A2.N_ABSMEMBER_ID
AND A1.C_NAME= ? OR A2.C_NAME= ?);
DELETE FROM TAM_GROUPS_MEMBERS M
JOIN TAM_ABSMEMBER A1 ON M.N_GM_MEMBER_ID=A1.N_ABSMEMBER_ID
JOIN TAM_ABSMEMBER A2 ON M.N_GM_GROUP_ID=A2.N_ABSMEMBER_ID
WHERE A1.C_NAME= ? OR A2.C_NAME= ?;
对于删除或更新多表关联,可以使用EXISTS语句改写上面的SQL
DELETE FROM TAM_GROUPS_MEMBERS M
WHERE EXISTS (SELECT * FROM TAM_ABSMEMBER A1, TAM_ABSMEMBER A2
WHERE M.N_GM_MEMBER_ID=A1.N_ABSMEMBER_ID AND M.N_GM_GROUP_ID=A2.N_ABSMEMBER_ID
AND A1.C_NAME= ? OR A2.C_NAME= ?);
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/26506993/viewspace-2128713/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/26506993/viewspace-2128713/