Re: Performing intersection without intersect operator

Поиск
Список
Период
Сортировка
Искать
От
Oliveiros Cristina
Тема
Re: Performing intersection without intersect operator
Дата
Msg-id
017501c938f3$75c0ae60$ec5a3d0a@marktestcr.marktest.pt
Список
Дерево обсуждения
Performing intersection without intersect operator "Nacef LABIDI" <nacef.l@gmail.com>
Re: Performing intersection without intersect operator Peter Eisentraut <peter_e@gmx.net>
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 -----
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
В списке pgsql-sql по дате отправления
Предыдущее
От: Nacef LABIDI
Дата:
Следующее
От: Peter Eisentraut
Дата:
FAQ