>That's why you need to do a replace now. Did you read my suggestion few messages back where I spelled it out for you?

Hold that thought

ok so i did

select otest.fname,cast(0 as integer) as clientid;
from otest;
inner join dup on;
dup.fname =otest.fname;
order by otest.fname

now that gave me the layout i wanted in that.
it now shows

0 peter
0 peter

but the only problem is when i do the replace all SQL you gave me it numbers from 1-20 which is the number of peeps i added to the table not based on the amount of times a person appears.

PS thanks 4 thehelp. lil brek thru :D