统计结果不再放到 B6里怎么办
schtg 老师你好。你对我在6月11日的帮助请求给了下面的代码。现在我想将这段代码的统计结果放到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.hz_1b
select h120g,h120c from t1 where h120c > 0 order by zxh into table B6
