Karsten Wutzke <karsten.wutzke_at_starconcept.com> wrote in message news:<3B7AF775.F7EA56C8_at_starconcept.com>...
> Hi all!
>
> What's the meaning of a "(+)" after a comparison in a WHERE statement?
>
>
> 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
>
> Sorry for dupe... I forgot the essential (+)
It's an outer join operator. It means you still want a row returned
from PERSONAL even if no KIND rows exist for your selection criteria.
Received on Thu Aug 16 2001 - 02:33:51 CDT
