Forum Discussion
Upgrade values in table
Hello ALL, I need to retrieve values a cost, a rate to a table, which are stock in another table. It is table fs_sro_labor_mst and Those tables have a mutual column. It is work_code. ...
If work_code is unique in the source table (fs_sro_labor_mst) and is also unique in the target table (you don't give a name), you can use SQL below, replace table1 with your target table name
UPDATE T1
SET
T1.cost = T2.cost,
T1.rate = T2.rate
FROM
table1 T1 INNER JOIN fs_sro_labor_mst T2 ON T1.work_code = T2.work_code --Replace table1 with your target table nameThank you rodgerkong, this is the solution what I was looking for 🙂
