Re: Where clause

From: Michael Landin Hostbaek <mich(at)the-lab(dot)org>
To: "news(dot)gmane(dot)org" <nis(at)superlativ(dot)dk>
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: Where clause
Date: 2007-06-27 08:12:59
Message-ID: 20070627081259.GR50866@mich2.itxmarket.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

news.gmane.org (nis) writes:
> SELECT * FROM
> (
> select cid,count(distinct contactid) from tracking where click =
> true group by cid
> ) c1
> FULL OUTER JOIN
> (
> select cid,count(distinct contactid) from tracking where view =
> true group by cid
> ) c2
> USING (cid);

That did the trick!

Many thanks,

Mike

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Dmitry Turin 2007-06-27 09:15:18 'comp.databases.theory'
Previous Message Wiebe Cazemier 2007-06-26 21:37:11 Re: Delete rules and functions