UPDATE dbo.PL_TRADEDETAIL_HIST SET AMT_ETM=AMT_APP,M10=AMT_ETM,M1=1 WHERE EXISTS (SELECT PT.TRADE_ID FROM dbo.PL_TRADEDETAIL PT WHERE PT.TRADE_ID=PL_TRADEDETAIL_HIST.TRADE_ID AND PL_TRADEDETAIL_HIST.AMT_ETM=PT.AMT_APP) UPDATE dbo.PL_TRADEDETAIL_HIST SET AMT_APP= M10 WHERE M1=1