>How would I write a SQL statement to show all duplicate records only, on a field, with no unique records?
>
>rec no field1 results => recno field1
>1 a 1 a
>2 b 3 a
>3 a 4 a
>4 a 6 d
>5 c 7 d
>6 d
>7 d
>

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