Re: outer join question

matt lewis wrote:
> Placing e to the left of d in the first and to the right in the second
> does not produce any difference. What am I doing wrong here?
Nothing. In the (+) notation the semantics is defined in the positioning of the (+), not in the order of the table references. To flip the join you need to flip the (+) to the other table's column.

Cheers
Serge

-- 
Serge Rielau
DB2 Solutions Development
IBM Toronto Lab