title: SQL Update a table based on join with anther table
body: <p>I am trying to update a table by joining the values with another table.
  Here's my query so far.</p>
  
  <pre><code>    UPDATE LOGIN  SET LOGIN.DISABLED_IND = 'N', LOGIN.DREASON = 'Test'
          FROM  CONTACT
          WHERE CONTACT.CONTACT_ID = LOGIN.CONTACT_ID 
          AND CONTACT.RID ='abc'
  </code></pre>
  
  <p>When i run this, i get this </p>
  
  <pre><code>[Error Code: 933, SQL State: 42000] ORA-00933: SQL command not properly ended
  </code></pre>
  
  <p>Thanks</p>