On Sat, Sep 10, 2005 at 18:56:10 +0200,
[EMAIL PROTECTED] 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
;
---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the mailing list cleanly
