Path: newssvr20.news.prodigy.com!newsmst01.news.prodigy.com!prodigy.com!news-FFM2.ecrc.net!newsfeed00.sul.t-online.de!t-online.de!newsfeed.freenet.de!news-feed1.de1.concert.net!EUnet.yu!not-for-mail
From: "Milan Smederevac" <smeky@gmx.net>
Newsgroups: comp.databases.oracle.misc
Subject: Re: What does the (+) mean?
Date: Mon, 2 Feb 2004 23:25:25 +0100
Organization: Public news server of EUnet Yugoslavia
Lines: 11
Message-ID: <bvmicm$uv$1@news.eunet.yu>
References: <GtkTb.189$TH3.3061@nnrp1.ozemail.com.au>
NNTP-Posting-Host: p-6.94.eunet.yu
X-Trace: news.eunet.yu 1075760343 991 213.240.6.94 (2 Feb 2004 22:19:03 GMT)
X-Complaints-To: abuse@EUnet.yu
NNTP-Posting-Date: Mon, 2 Feb 2004 22:19:03 +0000 (UTC)
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 5.50.4522.1200
X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4522.1200
Xref: newssvr20.news.prodigy.com comp.databases.oracle.misc:135262

> I have an SQL with the following line in the WHERE clause:
>
> CLR.REF1=SEASON.RCIDX(+)
>
> What does the (+) mean?

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).