clos tabl use bj scan upda ys set 拨交证号=bj.拨交证号 where 许可证号=bj.许可证号 sele bj ends
CLOSE DATABASE USE BJ ALIAS BJ SCAN UPDATE YS SET YS.拨交证号=BJ.拨交证号 WHERE ALLTRIM(YS.许可证号)==ALLTRIM(BJ.许可证号) ENDSCAN