-- MERGE UPDATE MERGE INTO IFT_FUND_STANDARD_PRICE_RESULT A USING ( SELECT TIMS_DATE,FUND_CODE,BM_INDEX,BM_RATE FROM IFT_FUND_STANDARD_PRICE_RESULT WHERE FUND_CODE ='10110' AND TIMS_DATE > '20130115' ) B ON ( A.TIMS_DATE = B.TIMS_DATE AND A.FUND_CODE ='10112' ) WHEN MATCHED THEN UPDATE SET A.BM_INDEX = B.BM_INDEX, A.BM_RATE = B.BM_RATE ============================================================..