title: Convert UPDATE with INNER JOIN from SQL for use in MySQL
body: <p>I'd like to convert this for us in MySQL:</p>
  
  <pre><code>UPDATE product 
  SET price = 12.95 
  FROM product 
      INNER JOIN product_to_category ON product.product_id = product_to_category.product_id 
      INNER JOIN category ON product_to_category.category_id = category.category_id 
          AND category.parent_id = 39
  </code></pre>
  
  <p>MySQL doesn't like the FROM portion, and I'm not sure that the INNER JOINs will work as written either.</p>