Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: outer join and OR
Let's say the two tables I'm trying to join are: Customer (eg. columns: col1, int1 and int2) and Notes. A customer may or may not have notes, so to pull all customers (with or without notes) I used outer join.
select customer.col1, customer.int1, customer.int2, notes.col1
from customer, notes
where customer.col1 = notes.col1(+)
and (customer.int1 = 'abc' OR customer.int2 = 'abc');
Since I cannot use an OR in an outer join, this doesn't seem to work. How can I solve this?
Tx,
LD
Chrysalis <cellis_at_iol.ie> wrote in article <34F4DEEA.4BD0_at_iol.ie>...
> Lily Djuniarti wrote:
> >
> > I need to perform an outer join and also use an OR operator, which I
learn
> > is not possible. Is there any way out ?
> >
> > Thanks,
> > LD
>
> I don't know.
> What are you trying to do?
> --
> Chrysalis
>
> FABRICATI DIEM, PVNC
> ('To Protect and to Serve')
> Terry Pratchett : "Guards, Guards"
>
Received on Wed Feb 25 1998 - 00:00:00 CST