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 endscanthanks
>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 >