title: Oracle Update statement with an Inner Join
body: <p>I am trying to write a simple update statement with an inner join, but the way I would do this in SQL server does not seem to be working in ORACLE.  Here is the Update: </p>
  
  <pre><code>UPDATE D
  SET D.USER_ID = C.USER_ID
  FROM D INNER JOIN C 
  ON D.MGR_CD = C.MGR_CD WHERE D.USER_ID IS NULL;
  </code></pre>
  
  <p>It seems like the error I am getting is on the <code>FROM</code>.  Can someone explain to meet what the cause of this is and how to work around it?</p>