select a.clbz00 ,a.lrrxm0,c.zyh000,c.xm0000,d.bmmc00,a.lrrq00,a.qyrq00,a.tzrq00,b.ypmc00,b.mcsl00,b.jldw00,a.ypyfmc,a.pcmc00 from bq_ypyz00 a,bq_ypyzmx b,zy_brxxb0 c,bm_bmbm00 d where b.ypnm00 in ('6644','5584','5572','6674','6000') 
and b.yzid00 in (select yzid00 from bq_ypyz00 where lrrq00 >='20170201'  and lrrq00 <='20170331') and a.yzid00 =b.yzid00 and a.zyid00 =c.zyid00 and c.dqbq00 =d.bmbh00