Re: Performing intersection without intersect operator

Nacef LABIDI wrote:
> I want to perform an intersection between several select queries but 
> without using the INTERSECT keyword.
> 
> select userid from orders where productid=1 INTERSECT select userid from 
> orders where productid=2
> 
> I want to transform it without the INTERSECT.

(select userid from orders where productid=1 UNION select userid from 
orders where productid=2) EXCEPT (select userid from orders where 
productid=1 EXCEPT select userid from orders where productid=2) EXCEPT 
(select userid from orders where productid=2 UNION select userid from 
orders where productid=1)