title: update with join statement mysql?
body: <p>Is this possible in mysql?</p>
  
  <pre><code>update table1 
  set column1 = (select column1 from table2  
                 inner join table3 
                 where table2.column5 = table3.column6);
  </code></pre>
  
  <p>Here is a <a href="https://stackoverflow.com/questions/2446764/oracle-update-statement-with-inner-join">a similar question for an Oracle DB</a>.</p>