UPDATE Country x, City y set x.Name=x.Name where x.Code=y.CountryCode;