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