title: UPDATE with INNER JOIN fails but related SELECT statement works
body: <p>Is there a reason why the following UPDATE statement produces an error</p>
  
  <pre><code>UPDATE `t1`
  INNER JOIN `t2` ON `t2`.`id`=`t1`.`t2_id`
  INNER JOIN `t3` ON `t2`.`t3_id` = `t3`.`id` AND `t3`.`a_id` = '123'
  WHERE `t2`.`date` &gt; '2012-08-14'
      AND `t2`.`status` = 'pending'
  SET `t1`.`active` = '0';
  </code></pre>
  
  <p>The error I get is:</p>
  
  <pre><code>#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'WHERE `t2`.`date` &gt; '2012-08-14' AND `t2`.`statu' at line 4
  </code></pre>
  
  <p>The following (related) SELECT statement works okay</p>
  
  <pre><code>SELECT `t1`.*
  FROM `t1`
  INNER JOIN `t2` ON `t2`.`id`=`t1`.`t2_id`
  INNER JOIN `carer` ON `t2`.`t3_id` = `t3`.`id` AND `t3`.`a_id` = '123'
  WHERE `t2`.`date` &gt; '2012-08-14'
      AND `t2`.`status` = 'pending'
  </code></pre>