Re: outer join not responding as expected

>>It doesn't matter where I put the (+), the output doesn't change.

It depends on your DATA, but Martin is right:

It should be 'WHERE a.file_id (+) = b.file_id '

Cheers.

Carlos. Received on Thu Feb 16 2006 - 01:39:16 CST