标题:优化代码
取消只看楼主
杂七杂八
Rank: 1
等 级:新手上路
帖 子:217
专家分:7
注 册:2018-2-20
结帖率:96%
已结贴  问题点数:20 回复次数:0 
优化代码
****VFP6.0***
Sele a.Num As NxjNum, a.xm As NxjXm,a.bm As NxjBm,;
       b.NUM As kqNUM, b.XM As kqxm,b.bm As kqbm;
       From kq  b, nxj  a;
       Where (b.xm=a.xm and b.num NOT In (Sele num From nxj)) OR b.num=a.num and b.xm NOT In (Sele xm From nxj);
       Into tabl byz
有kq,nxj二个表,字段名结构相同 kq(num,xm) nxj(num,xm)找出num和xm不一样的记录。
现想用VFP9.0的代码,能优化吗?
搜索更多相关主题的帖子: Sele From Num 优化 代码 
2020-11-26 20:32



参与讨论请移步原网站贴子:https://bbs.bccn.net/thread-504022-1-1.html




关于我们 | 广告合作 | 编程中国 | 清除Cookies | TOP | 手机版

编程中国 版权所有,并保留所有权利。
Powered by Discuz, Processed in 0.150827 second(s), 8 queries.
Copyright©2004-2024, BCCN.NET, All Rights Reserved