title: SQL Error: ORA-00933: SQL command not properly ended 00933. 00000 - "SQL command not properly ended"
body: <p>I have looked through this site and cannot find a similar scenario. I am trying to run the following code</p>
  
  <pre><code>SELECT st.storeid, s.noofitems
  FROM salestrnsaction AS st, soldvia AS s
  WHERE st.tid = s.tid
  ORDER BY noofitems ASC;
  </code></pre>
  
  <p>and am still receiving the 'SQL command not properly ended' error.</p>
  
  <p>More specifically, this is the message I am receiving. </p>
  
  <pre><code>SELECT st.storeid, s.noofitems
  FROM salestrnsaction AS st, soldvia AS s
  WHERE st.tid = s.tid
  ORDER BY noofitems ASC
  Error at Command Line : 287 Column : 22
  Error report -
  SQL Error: ORA-00933: SQL command not properly ended
  00933. 00000 -  "SQL command not properly ended"
  *Cause:    
  *Action:
  </code></pre>
  
  <p>Thanks.</p>