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)
--- 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? -- Best Regards, Tarlika Elisabeth Schmitz A: Because it breaks the logical sequence of discussion Q: Why is top posting bad? -- Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-sql
