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>Then you must add some more code....
>>>Select tty.telno from tty group by tty.telno having count(*)>1>>>
>>>>>>CLOSE all >>>>>>USE tty in 0 >>>>>>m.telno=telno >>>>>>INDEX on telno TO gg >>>>>> >>>>>>SCAN FOR telno==m.telno >>>>>> IF FOUND() >>>>>> replace typ WITH 1 >>>>>> ENDIF >>>>>>ENDSCAN >>>>>>brow >>>>>> >>>>>>>>>>>>
>>>>>Select tty.telno from tty group by tty.telno having count(*)