title: SQL UPDATE with INNER JOIN
body: <p>I'm trying to use this query</p>
  
  <pre><code>UPDATE products  
  SET products.product_price = '87.00000'
  FROM products
  INNER JOIN product_category
  ON products.product_id = product_category.product_id 
  WHERE product_category.category_id = '64'
  </code></pre>
  
  <p>However I receive this error: <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 'FROM table products INNER JOIN table product_category ON prod' at line 3</code></p>
  
  <p>I don't see any syntax error. I have made this query from examples on this forum.</p>