That doesn't tend to work in any SQL database I've ever used, though I'm
told Informix can do something similiar.
You need to insert the data into a temp table then delete the rows in the
base table, then insert back from the temp table. Yeah it is a pain.
John
"ivan" <IVANCCC@terra.es> wrote in message
news:9fq8eq$1cpd$1@news.tht.net...
> 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
>
>
>
