subject:"\[SQL\] RE\: Help with UPDATE syntax"

Re: [SQL] RE: Help with UPDATE syntax

2001-03-15 Thread Richard Huxton

From: "Michael Davis" <[EMAIL PROTECTED]> > 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 >

[SQL] RE: Help with UPDATE syntax

2001-03-15 Thread Michael Davis

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