Subject | multicolumn update with multicolumn subquery |
---|---|
Author | matej1602 |
Post date | 2003-09-15T15:34:54Z |
Is it possible (in some way) to make multicolumn update with
multicoumn subquery, like I can do in oracle (and db2)
UPDATE MyTable
SET (col1, col2,... colN) =
(SELECT value1, value2,... valueN
FROM SomeTable...)
Thanks for reply.
Matej
multicoumn subquery, like I can do in oracle (and db2)
UPDATE MyTable
SET (col1, col2,... colN) =
(SELECT value1, value2,... valueN
FROM SomeTable...)
Thanks for reply.
Matej