Re: Quick question re outer joins
- From: jo_holvoet@xxxxxxxx
- To: oracle-l@xxxxxxxxxxxxx
- Date: Fri, 23 Jul 2004 10:50:23 +0200
If the relationship to the new table is 1-N, it could potentially add rows
just like a regular join, couldn't it ?
mvg/regards
Jo
Nuno Souto <dbvision@xxxxxxxxxxxxxxx>
Sent by: oracle-l-bounce@xxxxxxxxxxxxx
07/23/2004 10:35
Please respond to oracle-l
To: Oracle L <oracle-l@xxxxxxxxxxxxx>
cc:
Subject: Quick question re outer joins
Hi folks. This is a quickie, but potentially nasty:
Imagine a table query, returning a given number of rows.
Now, add an outer join to another table and return a
column from that other table. NO additional query predicates
other than the outer join one.
Is there any way the number of rows returned from
the query would change?
AFAIK, an outer join does NOT add or subtract
rows from a result set. True?
--
Cheers
Nuno Souto
in sunny Sydney, Australia
dbvision@xxxxxxxxxxxxxxx
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //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@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Other related posts:
