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= ?);

Oracle 多表關聯刪除

相關文章