On Wed, 13 Jun 2012, Thomas Kellerer wrote:
> 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;
Thomas,
I wondered about this syntax, and doing each column separately.
Thanks for the correction,
Rich