Re: Outer Join to Multiple Tables

Alvin Sylvain wrote:

> Eg: Say you have a personnel table, with a join to a company
> table, but the person might not be employed, and a join to a
> school table, but the person might not be in school, etc.
>
> select p.name, c.name, s.name
> from personnel p, company c, school s
> where 1=1
> and p.companyname (+) = c.name
> and p.schoolname (+) = p.name

   Yes, you can do it in Oracle. The outer join must be the outermost one is based on the execution plan of join.

---
Name   : Lun Wing San
Title  : Oracle Application Developer of Hong Kong Productivity Council
         Oracle Database Administrator and System Administrator of QRC
Phone  : (852)27885841