Like this: ```UPDATE t1 SET ... FROM table1 t1 JOIN table2 t2 ON t1.id = t2.t1_id WHERE ... ```
Like this: