sql - update one table with data from another -

table 1:

id    name    desc ----------------------- 1           abc 2     b       def 3     c       adf 

table 2:

id    name    desc ----------------------- 1     x       123 2     y       345 

how run sql update query can update table 1 table 2's name , desc using same id? end result is

table 1:

id    name    desc ----------------------- 1     x       123 2     y       345 3     c       adf 

how can done for:

• sql server
• mysql
• postgresql
• oracle

for mysql:

update table1 join table2      on table1.id = table2.id set table1.name = table2.name,     table1.`desc` = table2.`desc` 

for sql server:

update   table1 set table1.name = table2.name,     table1.[desc] = table2.[desc] table1 join table2     on table1.id = table2.id