March 26, 2021 SQL Merge Example MERGE INTO AH852TARH AS A USING ( SELECT ADZIP , ADSTORE FROM AH852ADR ) AS B ON A.TASTORE = B.ADSTORE WHEN MATCHED THEN UPDATE SET TAZIPCD = B.ADZIP