On Tue, 2003-02-25 at 17: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 )
:) So close
select count(distinct cp.person_id) from...
--
Rod Taylor <rbt@rbt.ca>
PGP Key: http://www.rbt.ca/rbtpub.asc