hi,
is this code make the same, if yes
if not found how i can insert at typ (empty)

CLOSE all
INSERT INTO sss.typ;
select *from tty WHERE tel  in(select tel FROM sss);

thanks.
>>hi all,
>>
>>any help.
>>i try to compare between 2 tables as under , but no result
>>
>>

>USE tty in 0
>    m.tel=tel
>    m.typ=typ
>
>USE sss in 0
>SELECT tty   &&& add this line
>scan
>   LOCATE FOR tel=m.tel
>     IF FOUND()
>       replace typ with m.typ
>     ELSE
>       replace typ WITH  SPACE(10)
>endif
>endscan
>