On Tue, 2003-02-25 at 14:03, James Cooper wrote:
> select distinct cp.person_id from cluster_person cp, cluster c where
> cp.cluster_id = c.cluster_id and c.c_id = 1
>
> can this query be changed to give just the row count?( of the distinct
> rows )
select count(distinct cp.person_id) from ...
Is that what you were after?
Brad Hilton
VPOP Technologies, Inc.