title: Oracle error 00979
body: <p>Getting an error code for the following</p>
  
  <pre><code>SELECT EMP_ID, EMP_LNAME, EMP_FNAME, ASSIGN_ID, ASSIGN_COMP, SOFTWARE.SFT_ID, COUNT(SFT_TITLE)
  FROM EMPLOYEE, ASSIGN_PC, SOFTWARE
  WHERE EMPLOYEE.EMP_ID = ASSIGN_PC.ASSIGN_EMP
  GROUP BY SFT_TITLE
  </code></pre>
  
  <p>It runs fine when I take out the count and group by commands but I can't get it to run otherwise.  Any help is appreciated.</p>
  
  <p>thanks.</p>