>>Hi All:
>>
>>In the following table:
>>
>>

>>33333                Joe
>>44444                cat
>>33333                fish
>>

>>
>>What is the SQL syntax to retrieve only those records for which there are dupes, like so:
>>
>>

>>33333                Joe
>>33333                fish
>>

>>
>>Thanks,
>>
>>Yossi
>
>

>SELECT YourTable.*;
>FROM YourTable;
>INNER JOIN (SELECT Field1;
>                   FROM YourTable;
>            GROUP BY Field1;
>            HAVING COUNT(*) > 1) Tbl1 ON Tbl1.Field1 = YourTable.Field1
>

>
>
>UPDATE !!!!
>Sorry I didn't saw your versions on VFP.
>In VFP5:
>

>SELECT Field1;
>FROM YourTable;
>GROUP BY Field1;
>HAVING COUNT(*) > 1;
>INTO CURSOR Tbl1
>
>SELECT YourTable.*;
>FROM YourTable;
>INNER JOIN  Tbl1 ON Tbl1.Field1 = YourTable.Field1
>

Will this version work in VFP5?

select * from YourTable where Field1 in (select Field1 from YourTable GROUP BY Field1 having count(*)>1)