Re: UPDATE with value from another table

On Sat, 2002-03-02 at 05:08, Thomas T. Thai wrote:
> UPDATE [ ONLY ] table SET col = expression [, ...]
> [ FROM fromlist ]
> [ WHERE condition ]
>
> Is this valid:
>
> UPDATE table1
> SET col = table2.col
> FROM table2
> WHERE col = table2.id;

Yes, in principle:

junk=# UPDATE table1
junk-# SET col = table2.col
junk-# FROM table2
junk-# WHERE col = table2.id;
ERROR: Column reference "col" is ambiguous

WHERE table2.col = table1.id;

--
Oliver Elphick Oliver(dot)Elphick(at)lfix(dot)co(dot)uk
Isle of Wight http://www.lfix.co.uk/oliver
GPG: 1024D/3E1D0C1C: CA12 09E0 E8D5 8870 5839 932A 614D 4C34 3E1D 0C1C

"I will lift up mine eyes unto the hills, from whence
cometh my help. My help cometh from the LORD, which
made heaven and earth."
Psalms 121:1,2