title: How can I do three table JOINs in an UPDATE query?
body: <p>I asked a question and got this reply which helped.</p>
  <pre><code>   UPDATE TABLE_A a JOIN TABLE_B b
     ON a.join_col = b.join_col AND a.column_a = b.column_b
     SET a.column_c = a.column_c + 1
  </code></pre>
  <p>Now I am looking to do this if there are three tables involved something like this.</p>
  <pre><code>    UPDATE tableC c JOIN tableB b JOIN tableA a
  </code></pre>
  <p>My question is basically... is it possible to do three table joins on an <code>UPDATE</code> statement? And what is the correct syntax for it?</p>
  <p>Do I do the following?</p>
  <pre><code> JOIN tableB, tableA
   JOIN tableB JOIN tableA
  </code></pre>