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)