Re: What does the (+) operator mean in sql queries?
From: PMG <stilvi_at_hotmail.com>
Date: Mon, 15 Apr 2002 00:32:54 +0300
Message-ID: <a9csk2$gli$1_at_ulysses.noc.ntua.gr>
Date: Mon, 15 Apr 2002 00:32:54 +0300
Message-ID: <a9csk2$gli$1_at_ulysses.noc.ntua.gr>
OUTER JOIN
[Quoted] [Quoted] "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:32:54 CEST