[SQL] update from another table

[ivan]

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




---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
    (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])