SELECT V.RCLXMC,V.YPMC00,V.YPGG00,V.JZRQ00,V.SHRQ00,V.JZSJ00,V.ZY0000,V.SFSH00, 
 B.KCDW00 JZDW00,B.K2J000 ZHL000,V.GJDJ00,V.FCDJ00,V.PFDJ00,
ROUND(V.FCSL00*V.ZHL000/B.K2J000,4) FCSL00,V.GJDJ00 as FCGJDJ,
V.FCJE00,V.DJH000 AS CKDH00,V.YPBM00,V.PYSM00,V.ZBQMC0,V.SF4J70,(select MC0000 from VW_YK_YDYPXZ where BH0000=B.YPXZ00) YPXZ00, 
V.LSDJH0,V.CRBMMC,V.LBMC00,V.YLMC00,V.YPMLBZ,V.GJFCJE,V.GHDWMC,V.SCPH00,V.YPSXRQ 
FROM VW_YK_CKJZ00 V,BM_YD0000 B
where
 V.YKBMBH+0=41
 and
  V.YPNM00=B.YPNM00
 AND V.CRBMBH like '%'
AND V.RCLXBH<>'08' 
 AND V.JZRQ00>='20200415' AND V.JZRQ00<='20200415' 
 AND V.JZRQ00||V.JZSJ00>='2020041500:00:00' AND V.JZRQ00||V.JZSJ00<='2020041523:59:59' 
 and ( (V.YLBH00 like '%'   ) or  (''='-1') or  (''='WZ') )    
 /* and ((V.TYMBH0='' or ''='ALL') or (''='-1') ) */
 and V.YPNM00=10520 
ORDER BY V.JZRQ00,V.JZSJ00,V.DJH000,V.MXZLSH