exclude part of result

From: Tarlika Elisabeth Schmitz <postgresql(at)numerixtechnology(dot)de>
To: pgsql-sql(at)postgresql(dot)org
Subject: exclude part of result
Date: 2008-06-26 23:35:38
Message-ID: 20080627003538.2d0132ce@dick.coachhouse
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql


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?

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message A. Kretschmer 2008-06-27 06:48:53 Re: exclude part of result
Previous Message Montaseri 2008-06-26 20:17:13 Re: ANSI Standard