Re: SQL: What's the meaning of (+)?

From: Henning Follmann <henning_at_odin.follmann-net>
Date: Wed, 15 Aug 2001 20:14:46 -0400
Message-ID: <slrn9nm43c.fa.henning@odin.follmann-net>

On Thu, 16 Aug 2001 00:26:26 +0200,
Karsten Wutzke <karsten.wutzke_at_starconcept.com> wrote:
>Hi all!
>
>What's the meaning of a "(+)" after a comparison in a WHERE statement?

It's an outer join.

>
>
>SELECT p.PNR, k.KIND
>FROM PERSONAL p, KIND k
>WHERE p.pnr = k.PNR AND p.PNR < 130
>
>I've just stumbled across it in the exam preparations, but I can't find
>it documented somewhere in my papers.
>
>Thanks for helping!
>
>Karsten
>
>PS: PERSONAL is PERSONELL or EMPLOYEES, KIND is CHILD
>

-- 
Henning Follmann
8 Jane Road
New Providence, NJ 07974
Tel.: +1 908 464 8972
H.Follmann_at_gmx.de


-----=  Posted via Newsfeeds.Com, Uncensored Usenet News  =-----
http://www.newsfeeds.com - The #1 Newsgroup Service in the World!
 Check out our new Unlimited Server. No Download or Time Limits!
-----==  Over 80,000 Newsgroups - 19 Different Servers!  ==-----

Received on Wed Aug 15 2001 - 19:14:46 CDT