Re: What's Outer Join?

ªü´ö Thenardier wrote:
>
> As title. And in some SQL statement used in Oracle,
> i can see WHERE TableA.Col1 = TableB.Col1 (+) or
> sth like WHERE TableA.Col1 (+) = TableB.Col1 .
> What do they mean?
>
> Thanks!
>
> Thenard

It means that..
If u don't have that (+) sign u get all the records that match that "EQUAL" clause in the "WHERE" condition. With an Outer join, u get additional values. U get all the ones that match the normal "EQUAL" criteria and all those values from the table without the ( + ) sign. U got to understand it as..
 The SQL gives out null rows in the WHERE condn. for all those extra records in the table w/o (+) sign.
So it implies that u get all the records from the table w/o the (+) sign & all matching records from the one with the (+) sign.

Thanks,
Avinash Received on Mon Dec 29 1997 - 00:00:00 CST