Re: Where clause

["news.gmane.org" <nis(at)superlativ(dot)dk>]

Michael Landin Hostbaek skrev:
> Hello, 
> 
> I have a table called tracking, with a contactid varchar, click bool,
> view bool and cid varchar.
> 
> I would like to put the following into one single query if possible:
> 
> // Number of clicks
> select cid,count(distinct contactid) from tracking where click =
> true group by cid; 
> 
> // Number of views
> select cid,count(distinct contactid) from tracking where view =
> true group by cid; 

Untested, not the cleverest formulation, but something like this should
work:

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);