title: SQL Command not properly ended in update statement
body: <p>Have 2 tables, <code>INVN_SBS</code> and <code>INVC_ITEM</code>.<br/>
  Looking to set the one field in the table to <code>active = '0'</code> based on criteria of if <code>INVN_SBS.ITEM_SID</code> and <code>INVNSBS.ITEM</code> match and <code>INVN_SBS.DCS_CODE = 'SMP'</code></p>
  
  <p>So far i have:</p>
  
  <pre><code>UPDATE INVN_SBS 
  SET ACTIVE='0' 
  FROM 
     INVN_SBS,
     INVC_ITEM 
  WHERE 
         INVN_SBS.ITEM_SID = INVC_ITEM.ITEM_SID
     and INVN_SBS.DCS_CODE='SMP'
  </code></pre>
  
  <p>However when run I get:</p>
  
  <blockquote>
    <p>ORA-00933:SQL Command not properly ended. </p>
  </blockquote>
  
  <p>Am able to run a select statement to show me the item that match my criteria but the update is giving trouble. </p>