sql - Update multiple rows by joining many tables

Question

I have 3 tables, i'm trying to find a way to update multiple rows using other tables data. Update only null or empty "info" column in table1 with "data" column in the Table2 by checking if the id in table1 is linked to the idTab1 in table3 and the id in table2 is linking to idTab2 in Table3

enter code here
Table1
id, info
 --------
 1, null
 2, info2
 3, null
 
 Table2
 id, data
  ---------
  1, info1
  2, info2
  3, info4

 Table3
 idTab1, idTab2
 ------
 1, 1
 2, 2
 3, 3

The desired result is :

Table1
id, info
--------
 1, info1
 2, info2
 3, info3

Thank you in advance.

Answer 1

You can join the 3 tables in the UPDATE statement with this syntax:

UPDATE Table1
SET Table1.info = t2.data
FROM Table3 t3 INNER JOIN Table2 t2
ON t2.id = t3.idTab2
WHERE t3.idTab1 = Table1.id AND Table1.info IS NULL

See the demo.
Results:

> ID |  INFO
> -: | ----:
>  1 | info1
>  2 | info2
>  3 | info4