Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: What does the (+) operator mean in sql queries?
outer join
"George Weer" <RubberDucky703_at_hotmail.com> schrieb im Newsbeitrag
news:a9cs7u$272i5$1_at_ID-116287.news.dfncis.de...
> Hello,
>
> I have a query which is this:
>
> SELECT supplier.id
> FROM supplier, order
> WHERE supplier.id = order.suppid (+)
> AND order.suppid IS NULL;
>
> I'm curious as to what the (+) is for in the query. I'm new in a job
which
> uses alot of oracle and i'm just starting.
>
>
>
> --
> Thanks lots
>
>
> Sorry for C/P not sure where to post.
>
>
Received on Mon Apr 15 2002 - 11:23:27 CDT