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; I guess I have to put where (click = true or view = true) - and differentiate them in the SELECT target.. ? Many thanks for any input, Mike ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend
