>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