SQL Update Query Using Join

25 Şub
UPDATE
 A
SET
 A.CityName = B.Name
FROM
 County A
JOIN
 City B ON A.CityId= B.CityId
WHERE
....