Translate JOIN syntax from LEFT JOIN, RIGHT JOIN to (+)
594752Oct 5 2007 — edited Oct 5 2007I have looked through a lot of documentation, but have yet to see some concreate examples of how to code a JOIN when you are used to LEFT, RIGHT JOIN, etc.
Could someone translate these, removing the LEFT OUTER JOIN, etc. and replace with the (+). I am fairly new to Oracle and have been using the others all along?
SELECT *
FROM LOCATION L
LEFT OUTER JOIN DEPT D
ON (L.LocationID = D.LocationID)
LEFT OUTER JOIN EMPLOYEE E
ON (D.DeptID = E.DeptID);
SELECT *
FROM EMPLOYEE E
RIGHT OUTER JOIN DEPT D
ON (D.DeptID = E.DeptID)
RIGHT OUTER JOIN LOCATION L
ON (L.LocationID = D.LocationID);
SELECT *
FROM LOCATION L
FULL JOIN DEPT D
ON (L.LocationID = D.LocationID)
FULL JOIN EMPLOYEE E
ON (D.DeptID = E.DeptID);
Thank you.