title: Update different columns using inner join
body: <p>Is it possible to put these 2 codes in just one line of code? What needs to change?</p>
  
  <pre><code>UPDATE table1 AS t1 INNER JOIN table2 AS t2 ON t1.id = t2.id SET t1.column2 = 1;
  UPDATE table1 AS t1 INNER JOIN table3 AS t3 ON t1.id = t3.id SET t1.column3 = 1;
  </code></pre>
  
  <p>Thanks.</p>