On Fri, 27 Jun 2008 07:17:11 -0700 (PDT) Lennin Caro <[EMAIL PROTECTED]> wrote:
> > select * from ( > SELECT DISTINCT a, b, c, now(), count(item_pk) > FROM product > LEFT JOIN item ON item.product_fk = product_pk > WHERE ... > GROUP BY a, b, c > ) t1 where not exists (select a,b,c, from navigation t2 where t2.a = > t1.a and t2.b = t1.b and t2.c = t1.c) Many thanks - there seems to be half a dozen ways of achieving the desired result! > > --- On Thu, 6/26/08, Tarlika Elisabeth Schmitz > <[EMAIL PROTECTED]> wrote: From: Tarlika Elisabeth > Schmitz <[EMAIL PROTECTED]> Subject: [SQL] exclude part > of result To: pgsql-sql@postgresql.org > Date: Thursday, June 26, 2008, 11:35 PM > > SELECT DISTINCT a, b, c, now(), count(item_pk) > FROM product > LEFT JOIN item ON item.product_fk = product_pk > WHERE ... > GROUP BY a, b, c > > > I have another table 'navigation' which also has the columns a,b,c > > If the combination of (a,b,c) exists in 'navigation', then exclude it > from above result. How can I achieve this? -- Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-sql