Re: outer join and OR

I think the following statement should work:

select * from
  ( select customer.col1, customer.int1, customer.int2, notes.col???     from customer, notes
    where customer.col1 = notes.col1(+)
  )
where int1 = 'abc'

   OR int2 = 'abc';

Stephan Schaefer
stesch_at_camline.com

Lily Djuniarti wrote:

> 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?
Received on Thu Feb 26 1998 - 00:00:00 CST