This is called "outer join" . I recommend that you look it up in Oracle
docs or a good general SQL book. Also, you should start using ANSI-style
syntax for outer joins (that is, if you are using Oracle 9) - it is much
more powerful and much less ambigious
"BenignVanilla" <BenignVanillaMYSPLEEN_at_tibetanbeefgarden.com> wrote in
message news:b3o1dg$1nmm48$1_at_ID-152254.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?
>
> --
> BenignVanilla
> tibetanbeefgarden.com
> x-no-archive: yes
>
> Remove MY SPLEEN to email me.
>
>
Received on Fri Feb 28 2003 - 11:26:57 CST
