Обсуждение: replace EXCEPT by JOIN

Поиск
Список
Период
Сортировка

replace EXCEPT by JOIN

От
T E Schmitz
Дата:
The following construct does what I need but is there a better way of 
expressing this?



select * from
(

SELECT DISTINCT section.section_pk
FROM ITEM LEFT JOIN product product ON Item.product_fk = product.product_pk LEFT JOIN section section ON
product.section_fk= section.section_pk
 
WHERE item.export = 'f'

EXCEPT

SELECT DISTINCT section.section_pk
FROM ITEM LEFT JOIN product product ON Item.product_fk = product.product_pk LEFT JOIN section section ON
product.section_fk= section.section_pk
 
WHERE item.export = 't'

) as X