Re: update from another table

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(at)terra(dot)es> wrote in message
news:9fq8eq$1cpd$1(at)news(dot)tht(dot)net(dot)(dot)(dot)
> 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
>
>
>