hi,
thank you for reply,
unforsuntly i don't have vfp9,

and I wish you have a time.

still i forget somthing about the last code.
thanks.
>I don't have the time to show you in details, but you have done this completely wrong!
>
>1. Open the two tables, Set relation properly, and Replace all for ..
>
>To add the not found records:
>1. Make a table of the not found by a simple SQL Select into a cursor
>2. Append from this cursor to add the not found records
>
>And by the way, with VFP9, you can do this with two lines of code, one to update, and one line to insert the missing records.
>
>>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
>>>