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