MERGE INTO %Table(OH_TL_PT_TMP) TMP USING (SELECT * from PS_OH_S_TL_ERNCD ERNCD, PS_TL_PAYABLE_TIME TLPT WHERE ERNCD.TRC = TLPT.TRC AND ERNCD.PAY_SYSTEM = TLPT.PAY_SYSTEM AND TLPT.DUR >= TO_DATE('2008-01-01' , 'YYYY-MM-DD') ) X ON (X.EMPLID = TMP.EMPLID AND X.EMPL_RCD = TMP.EMPL_RCD AND X.DUR = TMP.DUR AND X.SEQ_NBR = TMP.SEQ_NBR AND X.SETID_DEPT = TMP.SETID AND X.DEPTID = TMP.DEPTID) WHEN MATCHED THEN UPDATE SET TMP.TL_ERNCD = X.TL_ERNCD