UPDATE 여러테이블 조인

MERGE /*+ USE_HASH(A B) */ INTO TN_NPQ_LAB_QRANT_ITM A USING ( SELECT DISTINCT A.LAB_RQST_NO, A.REC_SEQ, C.PRDLST_NM, C.BOT_NM FROM TN_NPQ_LAB_QRANT_ITM A, TN_NPQ_LAB_QRANT_REQST B, TN_NPQ_REQST_DETAIL C WHERE A.LAB_RQST_NO = B.LAB_RQST_NO AND B.OFF_CD = C.OFF_CD AND B.REC_NO = C.REC_NO AND A.REC_SEQ = C.REC_SEQ AND C.OFF_CD = '10' AND C.REC_NO = '17292334' ) B ON (A.LAB_RQST_NO = B.LAB_RQST_NO ..

원문링크 : UPDATE 여러테이블 조인