scan SELECT aa2005.no,aa2005.salar,thred2.no,thred2.salar FROM aa2005,thred2 WHERE aa2005.no=thred2.no; into cursor curdummy nofilter replace thred2.salar WITH curdummy.salar_a FOR thred2.no=curdummy.no_a endscan skip>hi,
>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
>>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 >>