回复 2楼 啸凡
有一个新表 jieguo
里面有a1 --a7 这样的字段 每次查询不同的结果,分别放置到a1到a7中去
select bj,count(1) from cj1 group by bj where aabmc<=29 and yybmc<=29
select bj,count(1) from cj1 group by bj where aabmc<=29 and ssbmc<=29
select bj,count(1) from cj1 group by bj where aabmc<=29 and eebmc<=29
select bj,count(1) from cj1 group by bj where aabmc<=29 and wwbmc<=29
select bj,count(1) from cj1 group by bj where aabmc<=29 and hhbmc<=29
select bj,count(1) from cj1 group by bj where aabmc<=29 and bbbmc<=29
select bj,count(1) from cj1 group by bj where aabmc<=29 and xxbmc<=29
分别把查询的结果放到jieguo表中! 表的第一个字段是bj字段 有记录