Re: how to update with a join?

On Sat, Sep 10, 2005 at 18:56:10 +0200, MichaelHoeller@t-online.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
;