5.0¸ú×Ù£º
select a.ZYID00,a.BAH000,b.ZYH000,XM0000,CJYSBH,CJYSXM,CJRQ00,GDRQ00,DQKSBH,BMMC00,JXBZ00,KFBZ00 from 
ZS_BLXX01 a inner join ZY_BRXXB0 b on a.ZYID00=b.ZYID00 inner join BM_BMBM00 c on a.DQKSBH=c.BMBH00 where 
BLZT00='3' and BLJSDJ<='3' and GDRQ00>='20101209' and GDRQ00<='20150129' and ((KFBZ00='1' and DQKSBH=20) or (KFBZ00='2'))

9.0¸ú×Ù£º
select a.ZYID00,a.BAH000,b.ZYH000,XM0000,CJYSBH,CJYSXM,CJRQ00,GDRQ00,DQKSBH,BMMC00,JXBZ00,KFBZ00 from 
ZS_BLXX01 a inner join ZY_BRXXB0 b on a.ZYID00=b.ZYID00 inner join BM_BMBM00 c on a.DQKSBH=c.BMBH00 where 
BLZT00='3' and BLJSDJ<='0' and GDRQ00>='20101209' and GDRQ00<='20150129' and ((KFBZ00='1' and DQKSBH=2229) or (KFBZ00='2'))