>>
SELECT field1, COUNT(*) as matchrecs FROM <i>blah</i> GROUP BY field1 HAVING matchrecs > 1 INTO CURSOR <i>foo</i>
>>
>>SELECT * FROM <i>blah</i> WHERE field1 IN (SELECT field1 FROM <i>foo</i>) INTO CURSOR Dups
>
>Ed: Is there an advantage to doing this in two steps rather than one statement such as
>
>SELECT * FROM table WHERE field1 IN (SELECT field1 FROM table GROUP BY field1 HAVING COUNT(*) > 1)
>
It's easier to understand, and doesn't rely on the property COUNT(*) being published, since HAVING acts after the GROUP BY action occurs, and isn't explicitly carried forward in the sub-select.
>Thanks...........Rich