Outer Join to more than one table

[slimdave]

The SQL is valid ... what would not bevalid would be:

SELECT e.empid, e.empname, d.deptname, c.clubname
FROM emp e, dept d, club c
WHERE e.deptid(+) = d.deptid AND
e.clubid(+) = c.clubid

To do the above you would outerjoin one table to another in an inline view, then outerjoin the inline view to the third table