>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?