Hi again,

After such great help in my last post I thought I had definately got my head around why the code kept failing.

However another part of the problem yields another set of error messages from SQL Developer

So, again if anyone can shed any light on this situation I would be eternally grateful.

Code:
CREATE OR REPLACE VIEW TOP_EARNER_PER_LOCATION
AS
SELECT E.FIRST_NAME || ' ' || E.LAST_NAME AS EMPLOYEE_NAME,
           L.REGIONAL_GROUP AS REGIONAL_GROUP, 
           E.SALARY AS SALARY, 
           J.JOB_ID 
FROM EMPLOYEE E
LEFT OUTER JOIN DEPARTMENT D
ON D.DEPARTMENT_ID = E.DEPARTMENT_ID
LEFT OUTER JOIN LOCATION L 
ON L.LOCATION_ID = D.LOCATION_ID
LEFT OUTER JOIN JOB J 
ON J.JOB_ID = E.JOB_ID
GROUP BY E.FIRST_NAME || ' ' || E.LAST_NAME
HAVING J.JOB_ID NOT IN (670,671,672)
;

REM #...SELECT STATEMENT TO RUN QUERY GOES HERE
Many thanks in advance and apologies for this being my second question today