On 05/31/13 15:33, David Salisbury wrote:
>
> And without trying too much ;), I'll bet there is no way to do this in SQL proper. i.e.
> I can't correlate an update with a select stmt, as in a correlated sub-query sort of way.
> So for this to work I would indeed need to write a function that "hard codes" the values
> within the update stmt.
I think this is what you want:
update atmos_sites asites
set stationid = my.stationid
from my_stations my
where asites.id = my.atmos_site_id;
HTH
Bosco.