>>>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.Field1 >>>>
>>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 >>>
>select * from YourTable where Field1 in (select Field1 from YourTable GROUP BY Field1 having count(*)>1)It worked!! Thanks.