오라클 조인해서 UPDATE하기

UPDATE RC_AGGREGATION AGG_T
SET AGG_T.MANAGEMENT_DEPT_UUID = (SELECT USER_GROUP_UUID
                                  FROM AC_USER_GROUP_HIST GS_T
                                  WHERE GS_T.PREVIOUS_USER_GROUP_UUID = AGG_T.MANAGEMENT_DEPT_UUID
                                    AND MAIN_DEPT_YN = 'Y'
                                    AND REG_YEAR = 2019
                                    AND REG_SEQ = 1)
WHERE EXISTS(SELECT 0
             FROM AC_USER_GROUP_HIST GS_T
             WHERE GS_T.PREVIOUS_USER_GROUP_UUID = AGG_T.MANAGEMENT_DEPT_UUID
               AND MAIN_DEPT_YN = 'Y'
               AND REG_YEAR = 2019
               AND REG_SEQ = 1)

 

참고한 글 : http://www.gurubee.net/article/79308