[SQL] Performing intersection without intersect operator

[Nacef LABIDI]

Hi all,

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.

Thanks to all

Nacef