>>
>>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..
If it's not broken, fix it until it is.
My Blog