UPDATE
A
SET
A.City = B.CityName_New
FROM
City AS A
INNER JOIN TepmCity AS B
ON A.PostalCode = B.PostalCode
WHERE
A.PostalCode = 3