|
#2
schtg4 天前 07:08
回复 楼主 yd1954
直接在后面加上一些判断代码和赋值代码即可，请试一试哈。
 程序代码：select distinct h12_0 as hz1g,min(xh) as zxh,000000 as hz1c from b5 group by h12_0 order by zxh into cursor t1 readwrite select h12_0,count(*) as zcs from b5 group by h12_0 into cursor t2 update t1 set t1.h120c = t2.zcs from t1,t2 where t1.h120g = t2.h12_0 select h120g,h120c from t1 where h120c > 0 order by zxh into table B6 SELECT B5 IF Fsize("h120c") > 0 else alter table B5 add h120c n(7,0) endif update B5 set B5.h120c = B6.hz1c from B5,B6 where B5.hz_1b = B6.hz1g |
现在我想将这段代码的统计结果放到B5的h120g,h120c字段里，不放到B6里。应该怎么改？我不会，请老师帮助。
B5被我改来改去，其中的字段与6月的不同。
select distinct h12_0 as hz1g,min(xh) as zxh,000000 as hz1c from b5 group by h12_0 order by zxh into cursor t1 readwrite
select h12_0,count(*) as zcs from b5 group by h12_0 into cursor t2
update t1 set t1.h120c = t2.zcs from t1,t2 where t1.h120g = t2.h12_0
select h120g,h120c from t1 where h120c > 0 order by zxh into table B6
只有本站会员才能查看附件，请 登录