title: MySQL Join clause in Update
body: <p>When trying to perform this query:</p>
  
  <pre><code>&gt;mysql_query("UPDATE contracts 
                SET x = '1' 
                FROM contracts 
                INNER JOIN employees 
                ON contracts.contract_employeeid=employees.employee_id 
                WHERE experience &gt;= '6'") or die(mysql_error());
  </code></pre>
  
  <p>I get the following error message:</p>
  
  <blockquote>
    <p>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 FROM contracts INNER JOIN employees ON contracts.contract_employeeid=employees.employee_id WHERE experience >= '6'</p>
  </blockquote>
  
  <p>In words, I need to set x=1 on the table "contracts" for the employees who have more than 6 years of experience (to do so, I need to join with the table "employees" on employee_id=contract_employeeid since their experience is stored in that table)</p>