title: Oracle update query using condition from another table
body: <p>I am trying to update a column in a table based on the below select statement.  The column I'm updating is not join condition and is a different value.</p>
  
  <pre><code>SELECT * 
  FROM TRANS DT, RECOVER RT
  WHERE DT.SERIAL_NUMBER =RT.SERIAL_NUMBER
  AND DT.DATE &gt;= TO_DATE('07/14/2016','mm/dd/yyyy')
  </code></pre>
  
  <p>I've tried the following and get errors.  Any assistance would be appreciated.</p>
  
  <pre><code>UPDATE TRANS
  SET CODE = SUCCESS
  WHERE (SELECT * 
         FROM TRANS DT, RECOVER RT
         WHERE DT.SERIAL_NUMBER = RT.SERIAL_NUMBER
           AND DT.DATE &gt;= TO_DATE('07/14/2016', 'mm/dd/yyyy')
  </code></pre>