Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Using the + statement in a Select statement

Re: Using the + statement in a Select statement

From: DA Morgan <damorgan_at_exesolutions.com>
Date: Fri, 28 Feb 2003 08:28:35 -0800
Message-ID: <3E5F8E33.29427A7C@exesolutions.com>


BenignVanilla wrote:

> I am working on a project where I am joining several tables. We found that
> not all of the tables had matching records, so we were getting many less
> records then expected. Someone suggested we use the + statement on the right
> side of our join statements...This solved the problem, returning the proper
> number of records.
>
> I can't find any documentation on the + statement. Can anyone educate me?
>
> --
> BenignVanilla
> tibetanbeefgarden.com
> x-no-archive: yes
>
> Remove MY SPLEEN to email me.

Go to http://tahiti.oracle.com and look up "OUTER JOIN".

The outer join is a fundamental concept in all relational databases so it is one you need to learn.

Daniel Morgan Received on Fri Feb 28 2003 - 10:28:35 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US