I have two UPDATE statements updating one table from two other look-up tables. The first update is fine, however the following updates overwrite the correct data with NULL. Both statements update the same column in table 1.....
Q. How do prevent multiple updates from overwriting each other???
SET col_2 = (SELECT col_2 FROM table2 t2 WHERE col_1 = t2.col_1)
SET col_2 = (SELECT col_2 FROM table3 t3 WHERE col_1 = t3.col_1))