UPDATE CUSTOMER_UNIT CU SET CUSTOMER_CD = ( SELECT CC.DEST FROM ARTICLE_CODE_CHANGE CC WHERE CU.customer_cd = CC.SRC ) WHERE EXISTS ( SELECT 1 FROM ARTICLE_CODE_CHANGE hoge WHERE hoge.SRC = CU.customer_cd );