Performing intersection without intersect operator

Поиск
Список
Период
Сортировка
От Nacef LABIDI
Тема Performing intersection without intersect operator
Дата
Msg-id f16f7ea00810280414xe6edc4fme3ab158625a73546@mail.gmail.com
обсуждение
Ответы Re: Performing intersection without intersect operator
Список pgsql-sql
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 по дате отправления: