Re: exclude part of result

Hi,

Two other ideas...

SELECT DISTINCT p.a, p.b, p.c, now(), count(item.item_pk)
FROM product p     JOIN    (select distinct a,b,c from  products     except     select distinct a,b,c from  navigation
 )foo      USING (a,b,c)    LEFT JOIN item ON item.product_fk = product_pk 
WHERE ...
GROUP BY p.a, p.b, p.c


or maybe

SELECT DISTINCT foo.*, now(), count(item.item_pk)
FROM (select distinct a,b,c from  products     WHERE ...     except     select distinct a,b,c from  navigation    )foo
   LEFT JOIN item ON item.product_fk = product_pk 
WHERE ...
GROUP BY p.a, p.b, p.c

HTH,

Marc Mamin