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: Rene Nyffenegger <rene.nyffenegger_at_gmx.ch>
Date: 28 Feb 2003 16:41:15 GMT
Message-ID: <b3o3fb$1nta6p$3@ID-82536.news.dfncis.de>

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

Search for 'outer join' in the documentation

Rene Nyffenegger

-- 
  no sig today
Received on Fri Feb 28 2003 - 10:41:15 CST

Original text of this message

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