Sorry to ask a newbie-type question, but isn't a full outer join like:
SELECT * FROM CLR, SEASON;
If (+) means "....meaning return all rows...." then (+) on both sides means
return everything from both tables, true?
--
Julian Milano
"FlameDance" <flamedance_at_gmx.de> wrote in message
news:c008a3$ec4$00$1_at_news.t-online.com...
> Milan Smederevac wrote:
> >>I have an SQL with the following line in the WHERE clause:
> >>
> >>CLR.REF1=SEASON.RCIDX(+)
> >>
> > That is right JOIN, in other words outer JOIN meaning return all rows
> > including that one that are NULL in SEASON table (showing all rows from
CLR
> > table).
>
> This one I understood and used. Additional question:
> How can I create a full outer join?
>
> WHERE CLR.REF1(+)=SEASON.RCIDX(+)
>
> is not allowed by the compiler.
>
> I found a workaround writing some PL/SQL code but is there a way to do
> it directly?
>
> Stephan
>
Received on Sun Feb 08 2004 - 19:46:04 CST
