Re: Question about (+) in WHERE clause
From: Mike Moore <hicamel_at_mail.home.com>
Date: Sat, 10 Nov 2001 02:34:08 GMT
Message-ID: <Am0H7.13774$Vf4.7439559_at_news1.rdc1.sfba.home.com>
Date: Sat, 10 Nov 2001 02:34:08 GMT
Message-ID: <Am0H7.13774$Vf4.7439559_at_news1.rdc1.sfba.home.com>
This is called an "outer join".
Chris <christos_tsoukalas_at_yahoo.com> wrote in message
news:1d9407f8.0111091143.5e07d76e_at_posting.google.com...
Now that you know what it is called, you should have no problem
looking it up even by searching on google.
Mike
> Hi,
>
> I try to debug a SQL statement of the form:
>
> SELECT E.FIRST_NAME, A.STATE
> FROM EMPLOYEES E, ADDRESS A
> WHERE E.LAST_NAME LIKE 'j%'
> AND E.ADDRESS_ID (+) =A.ADDRESS_ID
>
>
> I am not really sure what this (+) stands for. Do you know any Oracle
> documentation explaining the use of this symbol?
>
> Thanks,
> Chris
Received on Sat Nov 10 2001 - 03:34:08 CET