Re: RE: Help with UPDATE syntax

From: "Michael Davis" <mdavis@sevainc.com>

> Try eliminating the statement " from user_group_map map".  It does not
belong in the update.  Here is the fully rewritten statement:
>
> update
>          user_group_map
>     set
>          user_id = 4
>     where
>          user_id = 9 and
>          not exists (
>              select * from
>                    user_group_map ug2
>              where
>                     user_id = 4 and
>                     ug2.group_id = map.group_id and                                    ^^^
>                     ug2.role = map.role);                                ^^^
I take it these are actually "user_group_map"?

- Richard Huxton