update from another table

dear sir,

i would like to know how can i update a table with columns from another
table and adding a new column with a secuence,

i have try

update table
set column = (select column from table2), ......, set column=secuence..

is it right?????

thanks

ivan