Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Using the + statement in a Select statement
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
![]() |
![]() |