title: Joining columns from two tables into one
body: <p>I have 2 tables, EMPLOYEEAPP and EMPLOYEEINFO.</p>
  
  <p>I want to search to search the EMPLOYEEAPP table for the EMPLOYID when the SECURITYGROUP column is a certain value. </p>
  
  <p>I want to then take the EMPLOYID given from the EMPLOYEEAPP table and search for their corresponding first and last name with the EMPLID column in the EMPLOYEEINFO table.</p>
  
  <pre><code>SELECT EMPLOYEEAPP.EMPLOYID, EMPLOYEEINFO.FIRST_NAME, EMPLOYEEINFO.LAST_NAME
  FROM EMPLOYEEAPP
  WHERE EMPLOYEEAPP.SECURITYGROUP = 'ANALYST'
  INNER JOIN EMPLOYEEINFO
  ON EMPLOYEEAPP.EMPLOYID=EMPLOYEEINFO.EMPLID
  </code></pre>
  
  <p>I keep receiving the error "ORA-00933: SQL command not properly ended".</p>
  
  <p>Any help or insight would be greatly appreciated!</p>