Re: What does this mean (+)

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Wed, 7 Nov 2001 11:43:25 +0100
Message-ID: <tui531me2vsg44@corp.supernews.com>

"harry" <a_at_abc.com> wrote in message
news:mi2iutkon9aen4jt721rf0915tgdipts76_at_4ax.com...
> in a where clause i.e
>
> And E.CLE_ID = R.CLE_ID(+)
>
> thanks
>
> harry

outer join.
Records existing in E do not have to exist in R. Using the outer join records in E without a match will be shown removing the (+) reverts this statement to an inner join: unmatched records in E will not be shown.

Hth

--
Sybrand Bakker
Senior Oracle DBA

to reply remove '-verwijderdit' from my e-mail address

Received on Wed Nov 07 2001 - 04:43:25 CST