timezone shape country equals geoname_shape country

number of errors=0
number of warnings=0
Group=chkGrpTimezone

select timezoneid,geoname_timezone.countrycode,timezoneshapeid,geoname_timezone.sourcegeoshapeid, geoname_shape.countrycode from geoname_timezone,geoname_shape where geoshapeid=geoname_timezone.sourcegeoshapeid and geoname_timezone.countrycode<>geoname_shape.countrycode

update geoname_timezone set countrycode=geoname_shape.countrycode from geoname_shape where geoshapeid=geoname_timezone.sourcegeoshapeid and geoname_timezone.countrycode<>geoname_shape.countrycode;

timezoneid	countrycode	timezoneshapeid	sourcegeoshapeid	countrycode