A Tech Log

February 2, 2009

SQL updating a table with values from another table via a join

Filed under: Development — adallow @ 10:03 am
Tags:

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);

Advertisements

Create a free website or blog at WordPress.com.