Replacing Missing values from one table with values from another table
I have these two tables. See picture. t3 is my main table that has some missing values in col1, col2 and col3. I have this second table t4 on the right which has some backup values for col1, col2 and col3, and i would like to replace only the null values of t4 with the ones from t4 and get to the format below without any missing values. Essentially, t4 on the right has the categories, ID’s unique backup values.
Can you give me any suggestions using INNER JOIN and COALESCE for example? They are both temporary tables in a view query.
Thanks!
