UPDATE dbo.geo_postcode
SET dbo.geo_postcode.geo_region_name = dbo.geo_region.geo_region_name
FROM dbo.geo_postcode
INNER JOIN dbo.geo_region
ON (dbo.geo_postcode.geo_region_code = dbo.geo_region.geo_region_code and dbo.geo_postcode.geo_country_code = dbo.geo_region.geo_country_code);
February 2, 2009
SQL updating a table with values from another table via a join
No Comments Yet »
No comments yet.
RSS feed for comments on this post. TrackBack URI
Click link for feed