hi,
thank you ,it works.


>>i try ,but not works...bad try and thinking
>>

>>CLOSE all
>>USE tty in 0
>>INDEX on ncli TO gg
>>Select tty.telno,tty.typ from tty group by tty.telno,tty.typ having count(*)>1 READWRITE
>>replace typ with 1
>>

>>
>
>

>CLOSE all
>USE tty in 0
>INDEX on ncli TO gg
>Select tty.telno,tty.typ from tty group by tty.telno,tty.typ ;
>having count(*)>1 into cursor DupsOnly
>
>select tty.* from Tty inner join DupsOnly do on tty.telno = do.telno and tty.typ = do.typ into table myNewTableWithAllDuplicates
>
>>replace typ with 1
>>

>
>What do you want to do with the duplicates in the original table is not clear. Do you want to replace typ with 1 for all duplicate records?