in reply to Re: Re: Re: SQL Update Error
in thread SQL Update Error
Having used Sybase for 15+ years I'm really used to this syntax, and I find it quite powerful (and you can do the same thing with DELETE of course).update the_table set col1 = t2.col2 from the_table t1 , other_table t2 where t2.id = t1.id and t1.somecol = "some value" and t2.anothercol = "some other value"
Michael
|
|---|
| Replies are listed 'Best First'. | |
|---|---|
|
Re:* SQL Update Error
by pelagic (Priest) on Feb 19, 2004 at 09:31 UTC |