title: SQL update values based on join
body: <p>I'm trying to update values of one table based on criteria of second table.
  But something is wrong. Can you advise what I'm a doing wrong?</p>
  
  <pre><code>UPDATE food_serve
  SET food_serve_cost = food_serve_cost*1.15
  FROM food_serve JOIN fooditem  
  ON fooditem.food_item_no = food_serve.food_item_no
  WHERE food_type = 'M' ;
  </code></pre>
  
  <p>Using oracle sql. Error report -</p>
  
  <blockquote>
    <p>SQL Error: ORA-00933: SQL command not properly ended
    00933. 00000 -  "SQL command not properly ended"
    *Cause:<br>
    *Action:</p>
  </blockquote>