Subject multicolumn update with multicolumn subquery
Author matej1602
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