select a.szys00,b.zwxm00,count(a.zyid00) from zy_brxxb0 a,bm_ygbm00 b
 where ryrq00>='20120101' and ryrq00<='20121231' and a.BRZT00<>'9' and a.szys00=b.ygbh00 
group by a.szys00,b.zwxm00