select X.*,
case when D.MZDJ00<>'0' then  '麻醉' when D.DPDJ00<>'0' then  '毒品' when D.SJDJ00='1'  then  '精一' 
when D.SJDJ00>'1'  then  '精二' else '普通' end YPLBMC, 
D.YPBM00,B.BRZJBH,nvl(B.BRDH00,B.BRLXDH) DH0000,B.BRBLH0
FROM VW_YF_BRYY X,BM_YD0000 D,BM_BRXXB0 B 
WHERE X.YFBMBH+0='140.000000' AND X.YPNM00+0=D.YPNM00 
AND X.BRID00=B.BRID00 
 AND  (D.MZDJ00<>'0' OR D.DPDJ00<>'0' OR D.SJDJ00='1'  ) and  D.SJDJ00<'2' 
AND FYRQ00>='20241129' AND FYRQ00<='20241129' 
AND FYRQ00||FYSJ00>='2024112900:00:00' AND FYRQ00||FYSJ00<='2024112911:21:29' 
 --ORDER BY  YPMC00