²éѯ´²Î»¿âÐÅÏ¢
  select bqh000,(select bmmc00 from bm_bmbm00 where bmbh00 =a.bqh000 )bqmc00,count(*) bqjzkcs, (select count(*)from bm_cwk000 where bqh000=a.bqh000 and kcbz00 =1 and cwxz00 !=2)kcs000, (select count(*)from zy_brxxb0 where dqbq00=a.bqh000 and brzt00 ='21')drkrs0, (select count(*)from zy_brxxb0 where dqbq00=a.bqh000 and brzt00='20')ksyys0, (select count(*)from zy_brxxb0 where dqbq00=a.bqh000 and brzt00 like '1%')bqdrjzrs, (select count(*)from YS_BRZYSQ where bqh000=a.bqh000 and zt0000='3')ytzbrs, (select count(distinct brid00) from ys_brzysq where zt0000 in('1','2') and (zyid00 =0 or zyid00=-1 or zyid00 is null)and ksh000 in(select ksh000 from bm_bqks00 where bqh000=a.bqh000 and yxbz00='1'))mzszrs  FRom bm_cwk000 a group by bqh000 order by bqmc00,bqh000