Hi,
Could you please provide me the Merge SQL statement equivalent to this Update: ?
UPDATE TBL_TO_UPDATE TrgTbl
SET REMOVE = 2
WHERE TrgTbl.REMOVE = 7
AND EXISTS
(
SELECT 1
FROM TBL_HISTORY hist
WHERE (TrgTbl.ANALYSIS_DATE = hist.HIST_DATE)
AND TrgTbl.COL_UPD IN (SELECT COL_HIST FROM TBL_HISTORY WHERE HIST_DATE < TrgTbl.ANALYSIS_DATE ORDER BY HIST_DATE DESC FETCH FIRST 120 ROWS ONLY)
);