>>

>>SELECT MyField1, MyField2, COUNT(MyField1) AS HowMany ;
>>  FROM MyTable GROUP BY MyField1, MyField2
>>  HAVING HowMany > 1 INTO CURSOR MyResult
>>

>
>Jim,
>
>What if I really want both records for John, but not the one for Jim? This wasn't what I thought I needed before, now it is.
>
>Renoir

It could be done with EXISTS keyword in one select, but I usually use two for simplicity..