Re: SELECT query

Joel Burton wrote:

> On Wed, 14 Mar 2001, G. Anthony Reina wrote:
>
> > I think it would be something like:
> > select distinct subject, arm, rep from circles_proc where rep = (select
> > rep  from circles_proc where 5 = count(cycle));
>
> You're heading towards
>
> SELECT distinct subject, arm, rep FROM circles_proc WHERE rep IN
>   (SELECT rep FROM circles_proc GROUP BY rep HAVING COUNT(rep)=5);
>

Thanks Joel! That works fine.

-Tony