Re: UPDATE Syntax Check

Rich Shepard wrote on 13.06.2012 00:17:
>    One table, waterchem, with primary key 'site' has columns easting and
> northing with no values in them. A second table, sites, with primary key
> 'name' has values for easting and northing for each row. I want to update
> waterchem with the easting and northing values from sites. My proposed
> statement is,
>
>    UPDATE waterchem
>    SET waterchem.easting, waterchem.northing = sites.easting, sites.northing
>    FROM sites AS s
>    WHERE waterchem.site = s.name;
>
>    Is this correct? If not, what approach should I adopt?
>

No it's not quite correct:

UPDATE waterchem
   SET waterchem.easting = s.easting
       waterchem.northing = s.northing
FROM sites AS s
WHERE waterchem.site = s.name;