Re: Where clause

A. Kretschmer (andreas.kretschmer) writes:
> *untested*
> 
> select cid, sum(case when click = true then 1 else 0 end), sum(case when
> view = true then 1 else 0 end) from ...
> 

Thanks, but I need the DISTINCT contactid - I don't want the same
contactid counted twice.

Mike