UpDate - Statement 2007-01-12 - By Wendlandt, Guido
Back
Hello @(protected),
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
|
|
