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 ---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings