Re: Intersect

Ludovic wrote:
> Hello,
>
> I want to kbnow if there is a means to do a query which can be like
> this
>
> select a,b from table 1 where conditions
> intersect (a) (intersection only on column a)
> select a,b from table 1 where other conditions
> intersect(a)
> select a,b from table 1 where another conditions
> etc.
>
> without a join (because i can have a lot of different conditions)
>
> Thank you for your response

Have you considered an inner join on a?

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu (replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org