Hello @all,

I want to update approximately 400 rows on table_1 with data of table_2 but
I don't know how to do this.



I tried the following (but it is not working)



update TABLE_1 a set (a.num_Value,

              a.date_changed) = (SELECT b.num_Value, b.date_changed
FROM TABLE_2 b

                           WHERE a.col_num = b. col_num

                            and a.ID = b.ID

                            and a.sample = b.sample

                            and a.num_Value <> b.num_Value

                            AND b.col_num between 1000 and
1400)



Can you please help me



Mit freundlichen Grüßen / Yours sincerly



Guido Wendlandt





________________________________________________

Georgsmarienhütte GmbH

Neue Hüttenstraße 1

49124 Georgsmarienhütte

Tel.: +49-(0)5401-394723

FAX: +49-(0)5401-394598

Mobil: +49-(0)170-7857345

<http://www.gmh.de> http://www.gmh.de