1       11:00:31  SQL Execute: ORACLE - select A.*,B.YPMLBZ,(SELECT C.SCCJZW FROM BM_YPSCCJ C WHERE C.SCCJBH=B.SCCJBH) SCCJZW,(SELECT Y.GHDWMC FROM BM_YPGHDW Y WHERE Y.GHDWNM=B.GHDWNM) GHDWMC 
from VW_YF_YPTJCX A,(select LBBH00,YPNM00,YPMLBZ,SCCJBH,GHDWNM FROM BM_YD0000) B  
WHERE A.YPNM00 = B.YPNM00 
  AND A.YXBMBH=1069
  AND B.LBBH00 like '0%'
  AND A.QRRQ00>='20240105'
  AND A.QRRQ00<='20240105'
  AND A.QRRQ00||A.QRSJ00>='2024010500:00:00' AND A.QRRQ00||A.QRSJ00<='2024010523:59:59'
ORDER BY A.QRRQ00,A.YPTJPC,A.YPNM00