Michael Landin Hostbaek wrote:
> 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.
... GROUP BY cid
-- Richard Huxton Archonet Ltd