thank you for reply,and code

i try as below

insert into emplo  (empno, Tel) ;
select t2.empno, t1.Tel from tel t1 ;
LEFT JOIN emplo T2 on T1.empno = T2.empno where T2.empno =0
CLOSE all
USE emplo
COUNT TO m.s
? m.s= 1402  && it must be 1423 or more

USE tel
COUNT TO m.s
? m.s=1423
brow

is there away to do it as below&&

use tel
use emplo
scan for empno<>tel.empno

append blank

replace empno with tel.empno

endscan

>>hi all,
>>
>>i need help to append from table1 to table2 where no not equal no and update table2.tel with table1.tel ,
>>table1 structur not equal table structure2 ,table1. no equal tabl2.no
>>
>>as
>>
>>table1
>> no tel
>>1 234
>>2 2345
>>3 1111
>>4 2222
>>5 5555
>>table2 tel
>>1 0
>>2 0
>>3 0
>>6
>>7
>>
>>**************************
>>result at table2
>>
>>1 234
>>2 2345
>>3 1111
>>4 2222
>>5 5555
>>6
>>7
>>
>>thanks
>
>Try
>
>

>
>update T2 set tel = T1.tel from Table2 T2 inner join Table1 T1 on T2.NO = T1.No
>insert into Table2 (no, Tel) 
>select T1.not, T2.Tel from Table1 
>LEFT JOIN Table2 T2 on T1.no = T2.no where T2.no IS NULL