[SQL] 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

---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
      subscribe-nomail command to [EMAIL PROTECTED] so that your
      message can get through to the mailing list cleanly