Re: how to update with a join?

On Sat, Sep 10, 2005 at 18:56:10 +0200,
MichaelHoeller(at)t-online(dot)de wrote:
> Hello all,
>
> thanks for the answere to the prev. thread. With the help of them
> I solved the problme I used "not like" instead of <> and this leads
> to a problem. This works for me:
>
> update stamm
> set code = replace (code, 'k' , '')
> where code like '%k%' and code <> '%V%';
>
> I would still be interested to learn how to update a row when the result
> set is only reachable via a join.

You can use 'FROM' in an update statement to include other tables.
For example (doing a pointless self join):
UPDATE stamm
SET code = replace (code, 'k' , '')
FROM stamm a
WHERE a.code = code
;