>33333 Joe >44444 cat >33333 fish >>
>33333 Joe >33333 fish >>
SELECT YourTable.*; FROM YourTable; INNER JOIN (SELECT Field1; FROM YourTable; GROUP BY Field1; HAVING COUNT(*) > 1) Tbl1 ON Tbl1.Field1 = YourTable.Field1UPDATE !!!!
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