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

On Sun, 14 Apr 2002 22:27:38 +0100, "George Weer" <RubberDucky703_at_hotmail.com> wrote:

>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.

the + stands for outer join, which means there doesn't need to be a corresponding record present in thetable, the (+) is attached to, in this case orders. A supplier without orders will show. The strange thing here however is the query doesn't use the order table at all, and the query output would have been identical if you wouldn't have used the orders table at all. Hence it is unclear what you are trying to accomplish.
Questions about sql are best posted in .server

Hth

Sybrand Bakker, Senior Oracle DBA

To reply remove -verwijderdit from my e-mail address Received on Sun Apr 14 2002 - 17:00:57 CDT