Could you please explain me how to rewrite (+) old JOIN sysntax to ANSI JOIN syntax?
I tried like this but it is not working for me for more then two tables:
e.g.:
SELECT E.*, D.*, J.*
FROM EMPLOYEES E, DEPARTMENTS D, JOBS J
WHERE E.DEPARTMENT_ID(+)=D.DEPARTMENT_ID
AND E.JOB_ID(+)=J.JOB_ID
AND E.JOB_ID(+)='HR REP'
ORDER BY E.DEPARTMENT_ID;
Please help me !