Re: Quick question re outer joins

If it's 1 to N, it can find multiple corresponding rows instead of just one.

mvg/regards

Jo

Nuno Souto <dbvision_at_optusnet.com.au>
Sent by: oracle-l-bounce_at_freelists.org
07/23/2004 16:06
Please respond to oracle-l  

        To:     oracle-l_at_freelists.org
        cc: 
        Subject:        Re: Quick question re outer joins

jo_holvoet_at_amis.com apparently said,on my timestamp of 23/07/2004 6:50 PM:

> If the relationship to the new table is 1-N, it could potentially add
rows
> just like a regular join, couldn't it ?

How?
If it finds a corresponding row, it puts its column value in the output. If it doesn't, it puts a NULL there. How can that add rows?

-- 
Cheers
Nuno Souto
in sunny Sydney, Australia
dbvision_at_optusnet.com.au
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to:  oracle-l-request_at_freelists.org
put 'unsubscribe' in the subject line.
--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------



----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to:  oracle-l-request_at_freelists.org
put 'unsubscribe' in the subject line.
--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------