>>Can you show what exactly did you write? The query as I posted (even if posted from the top of my head) should have worked just fine.
>
>
>ok this is what i have exectpy
>

>select otest.*,dup.numrec from otest;
>order by otest.fbobname;
>inner join (select FName, count(*) as NumRec from oTest group by FName having count(*) > 1) Dup on
>otest.fbobname=dupfbobname
>

>
>It seems to run now but an does show me the names one below the other with the same names as i would hav wanted but. it also shows records that wasnt in the dup table an everytime i run it it says "unrecognized command verb" but apart from that seems ok

I'm sorry. Can you compare the query you wrote with mine and find 10 differences?

Please use the query exactly. What is this strange JOIN condition you put on? And also move ORDER BY clause at the end. In VFP Order BY doesn't really matter where you put it, but in SQL Server it does.