Re: Performing intersection without intersect operator

Howdy, Nacef,

Try this,

SELECT a.userid
FROM orders a
JOIN orders b
USING (userid)
WHERE a.productid = 1
AND b.productid = 2

Best,
Oliveiros

----- Original Message -----
From: Nacef LABIDI
To: pgsql-sql(at)postgresql(dot)org
Sent: Tuesday, October 28, 2008 11:14 AM
Subject: [SQL] Performing intersection without intersect operator

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