Re: [SQL] Performing intersection without intersect operator

[Oliveiros Cristina]

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@postgresql.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