hi,
i try as under i got one field replacment only, any idea

SELECT aa2005.no,aa2005.salar,thred2.no,thred2.salar FROM aa2005,thred2 WHERE aa2005.no=thred2.no
scan
replace thred2.salar WITH salar_a FOR thred2.no=aa2005.no
endscan

thanks
>hi all,
>any idea help.
>i try to replace field with another filed where field1=field2
>as under but something rong.
>

>close all
>use thred2 in 0
>index on no to kk
>use aa2005 in 0
>index on no to kk1
>scan
>replace thred2.salar with aa2005.salar for aa2005.no=thred2.no
>endscan
>