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

one more question:

[Quoted] How does the outer join work?

[Quoted] [Quoted] Does oracle do the supplier.id = order.suppid FIRST?

[Quoted] If so doesn't a join require two inputs so how does it then do the outer join? given that it has only the result of the join (i.e. supplier.id)??

Confused!

P.S. Your right Gerard the query returns a list of suppliers with no orders.

"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:59:33 CEST