title: UPDATE multiple tables in MySQL using LEFT JOIN
body: <p>I have two tables, and want to update fields in T1 for all rows in a LEFT JOIN.  </p>
  
  <p>For an easy example, update all rows of the following result-set:  </p>
  
  <pre><code>SELECT T1.* FROM T1 LEFT JOIN T2 ON T1.id = T2.id WHERE T2.id IS NULL  
  </code></pre>
  
  <p>The <a href="http://dev.mysql.com/doc/refman/5.6/en/update.html" rel="noreferrer">MySQL manual</a> states that:  </p>
  
  <blockquote>
    <p>Multiple-table UPDATE statements can use any type of join allowed in SELECT statements, such as LEFT JOIN.  </p>
  </blockquote>
  
  <p>But I cannot find the proper syntax for doing that in the documented multiple-tables UPDATE.  </p>
  
  <p>What is the proper syntax?</p>