Re: What does the (+) operator mean in sql queries?

From: George Weer <RubberDucky703_at_hotmail.com>
Date: Sun, 14 Apr 2002 22:50:23 +0100
Message-ID: <a9ctii$226rq$1_at_ID-116287.news.dfncis.de>


thanks

[Quoted] "PMG" <stilvi_at_hotmail.com> wrote in message news:a9csk2$gli$1_at_ulysses.noc.ntua.gr...
> OUTER JOIN
>
> "George Weer" <RubberDucky703_at_hotmail.com> wrote in message
> 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 Sun Apr 14 2002 - 23:50:23 CEST

Original text of this message