Hi questions about joins

[holdingbe]

Hi all,
I want to all data's from employees table as well as locations tables.I execute one query based on the ansi standard method...

query:

SELECT DISTINCT D.DEPARTMENT_ID,L.LOCATION_ID
FROM EMPLOYEES E LEFT OUTER JOIN DEPARTMENTS D
ON(E.DEPARTMENT_ID=D.DEPARTMENT_ID)
RIGHT OUTER JOIN LOCATIONS L
ON(D.LOCATION_ID=L.LOCATION_ID);

i got output but i write the same scenerio in oracle standard method

query:

SELECT DISTINCT D.DEPARTMENT_ID,L.LOCATION_ID
FROM EMPLOYEES E, DEPARTMENTS D,LOCATIONS L
WHERE E.DEPARTMENT_ID=D.DEPARTMENT_ID(+)
AND L.LOCATION_ID=D.LOCATION_ID(+);

but i got error like
ORA-01417: a table may be outer joined to at most one other table

please send answer to me

[debasisdas]

since the standard method have some drawbacks ,we use ANSI syntax. try to execute with out the predicate.

[holdingbe]

since the standard method have some drawbacks ,we use ANSI syntax. try to execute with out the predicate.

Hi friend,
please explain clearly.. ....please write a answer in smoothly


thanks regards
michael

[debasisdas]

try to execute the same query without using the predicates.