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
-----------------------------------------------------------------