title: Update statement with inner join on Oracle
body: <p>I have a query which works fine in MySQL, but when I run it on Oracle I get the following error:</p>
  
  <blockquote>
    <p>SQL Error: ORA-00933: SQL command not properly ended<br/>
    00933. 00000 -  "SQL command not properly ended"</p>
  </blockquote>
  
  <p>The query is:</p>
  
  <pre><code>UPDATE table1
  INNER JOIN table2 ON table1.value = table2.DESC
  SET table1.value = table2.CODE
  WHERE table1.UPDATETYPE='blah';
  </code></pre>