>Hello All
>so i messed up a table i had an records i enter even thou its the same can hav different client ids
>
>so i wrote this query
>

>SELECT COUNT(otest.fname) AS numrec,otest.fname,;
>    otest.prefix,otest.bday,otest.aoonumber,;
>   otest.id;
>     FROM MAINBASE!OTEST;
>GROUP BY otest.fname;
>HAVING (numrec) >(1);
>INTO TABLE dup
>

>
>so that works fine it opens a dup table an i see like
>

>Numrec   fname
>2                   peter
>3                      james
>

>but im trying to link the otest table an the dup table in such a way that instead of showing one row for Peter an moving to JAmes it will show me the two rows for peter and the three for james so i can do what i need to do with them. Im fully aware i can just go in the Db an manually do it but.dont really wanna do that way. Thanks

select T.*, Dup.NumRec from OTest T 
inner join (select FName, count(*) as NumRec from oTest group by FName having count(*) > 1) Dup
on T.Fname = Dup.Fname