UPDATE statement

[Shal2]

Hello everybody,

I have two tables, table1 and table2. Both have "barcode" column as primary key. Both have also got a column called "Weight"

I want to update "table1", column "Weight" with values from "table2", column "Weight" where the "barcode" of "table1" is equal to "barcode" of "table2".

How can I achieve this with the update statement. The table1 has about 30,000 rows, table2 has about 2000 rows.

Thank you,
Shalini

 

[zhavic]

UPDATE table1 SET Weight = table2.Weight
FROM table1
INNER JOIN table2 ON table1.Barcode = table2.Barcode

Zhavic

---------------------------------------------------------------
In the 1960s you needed the power of two Comodore64s to get a rocket to the moon. Now you need a machine which is a vast number of times more powerful just to run the most popular GUI.

 

[Shal2]

Thank you so much Zhavic,
It worked perfectly.

Also the quote at the end of your message is neat!

Regards,
Shalini.

 

[zhavic]

Thanks, glad I could help.

Zhavic


---------------------------------------------------------------
In the 1960s you needed the power of two Comodore64s to get a rocket to the moon. Now you need a machine which is a vast number of times more powerful just to run the most popular GUI.