Daily Notes: Multi-table Association Update

UPDATE AM_APPROVE_LIST_LOG_SAMMY A
	   SET (A.EMP_ID, A.APPROVER_SEQUENCE, A.APPROVER_ID) =
	       (SELECT B.EMP_ID, B.APPROVER_SEQUENCE, B.APPROVER_ID
	          FROM AM_APPROVE_LIST_SAMMY B
	         WHERE B.EMP_ID = A.EMP_ID
	           AND B.APPROVER_ID = A.APPROVER_ID)
	 WHERE EXISTS (SELECT 1
	          FROM AM_APPROVE_LIST_SAMMY C
	         WHERE C.EMP_ID = A.EMP_ID
	           AND C.APPROVER_ID = A.APPROVER_ID)
Copy the code