멀티업데이트

MERGE INTO TB_CONTRACT_MST M

USING

    (

        SELECT CONTRACTMST_NO, MAX(CUST_CRTFC_DT) AS CUST_CRTFC_DT

        FROM TB_CONTRACT_MST_AUTH

        GROUP BY CONTRACTMST_NO

    ) A

ON

    (

        M.CONTRACTMST_NO = A.CONTRACTMST_NO

    )   

WHEN MATCHED THEN

    UPDATE SET ETC_1 = CUST_CRTFC_DT