Outer Join to more than one table
Hai every body,
I need to write a query where a table is to be outer joined to two tables. But as you know its not allowed in SQL to have outer join to more than one table. Can any body suggest a work around?
For example if I have emp, dept and club with empid, deptid, clubid being the respective primary keys. if I need to select all the employees regard less of whether they have a club or department, the ideal query will 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(+)
which is illegal...
If any of new an alternative for this .. please suggest..
Click Here to Expand Forum to Full Width