Re: Question about (+) in WHERE clause

Hi Mike,

But does the position of (+) make any difference in the query?

That is, how the query:

   SELECT E.FIRST_NAME, A.STATE

   FROM      EMPLOYEES E, ADDRESS A
   WHERE     E.LAST_NAME LIKE 'j%'
   AND       E.ADDRESS_ID (+) =A.ADDRESS_ID

   FROM      EMPLOYEES E, ADDRESS A
   WHERE     E.LAST_NAME LIKE 'j%'
   AND       E.ADDRESS_ID =A.ADDRESS_ID (+)

Thanks,

Chris

"Mike Moore" <hicamel_at_mail.home.com> wrote in message news:<Am0H7.13774$Vf4.7439559_at_news1.rdc1.sfba.home.com>...
> This is called an "outer join".
> Now that you know what it is called, you should have no problem
> looking it up even by searching on google.
> Mike
>
>
> Chris <christos_tsoukalas_at_yahoo.com> wrote in message
> news:1d9407f8.0111091143.5e07d76e_at_posting.google.com...
> > 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 Mon Nov 12 2001 - 17:52:45 CET