>>I can easily do this with 2 statements, but what would be the SQL logic to Select only records where there were more than one meeting the criteria:
>>
>>

>>MyField1     MyField2
>>========     ========
>>John         12345
>>Jim          98765
>>John         12345
>>

>>
>>I only want this as a result:
>>
>>

>>John         12345
>>

>>
>>I only want 1 record with John and do not want Jim at all.
>>
>>Thanks, Renoir
>
>Try something like this;
>
>

>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