update Mstr set Wark = myCur.Wark from Mstr inner join MyCur on Mstr.No = myCur.Emp>>hi all,
>>select payroll >>zap >>append from dbf('mycur')&& ok >> >>****************************** >>***no errors no result >>SCAN >> M.EMP=mycur.employeeid >> M.MARK1=mycur.WARK >> replace MSTR.wark WITH M.MARK1 FOR MSTR.NO =M.EMP >>ENDSCAN >>>>thanks
>update Mstr set Wark = myCur.Wark from Mstr inner join MyCur on Mstr.No = myCur.Emp