오라클 조인 업데이트 join update

UPDATE HSB_LPIPE_EST_VALUE_EMC AA

SET (AODP_FTR_IDN) = (SELECT AREA_FTR_IDN FROM HSB_LPIPE B WHERE B.FTR_IDN =AA.FTR_IDN)