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 ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend