SELECT DISTINCT Q.CKDH00,Q.FYRQ00,Q.FYSJ00,Q.ZYH000,Q.LYRQ00,

Q.LYSJ00,Q.BRXM00,Q.BQBMBH,B.BMMC00,Q.QLZT00

 FROM YF_YZYPSQ Q,BM_BMBM00 B

 WHERE Q.YFBMBH=216

 AND  Q.ZYH000='00209447'

 AND  Q.FYRQ00>='20220101'

 AND  Q.FYRQ00<='20220620'

 AND  Q.FYRQ00||Q.FYSJ00>='2022010100:00:00' AND Q.FYRQ00||Q.FYSJ00<='2022062023:59:59'

 AND  Q.BQBMBH=B.BMBH00

 AND  Q.QLZT00 IN ('2','4','1','5','6')

 AND  Q.CXBZ00='Z'