Re: Quick question re outer joins

From: <jo_holvoet_at_amis.com>
Date: Fri, 23 Jul 2004 10:50:23 +0200
Message-id: <OF0B7343AB.7D5EB437-ONC1256EDA.003067AE@eu.amis.com>

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

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

        To:     Oracle L <oracle-l_at_freelists.org>
        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_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

Received on Fri Jul 23 2004 - 03:48:20 CDT