select a.*,SUBSTR(a.BRLX00,1,1)||' '||SUBSTR(a.brlx00,2,1)||' 号:' BRLXMC,SUBSTR(a.sqrq00,1,4)||'.'||SUBSTR(a.sqrq00,5,2)||'.'||SUBSTR(a.sqrq00,7,2) SQ0000,SUBSTR(a.PYRQ00,1,4)||'.'||SUBSTR(a.PYRQ00,5,2)||'.'||SUBSTR(a.PYRQ00,7,2) PY0000,SUBSTR(a.CBGRQ0,1,4)||'.'||SUBSTR(a.CBGRQ0,5,2)||'.'||SUBSTR(a.CBGRQ0,7,2)||' '||CBGSJ0 BG0000  from vw_jy_yw0000 a  WHERE ybh000='004369' and pyrq00='20230418' and BRXM00='叶财干' and rownum=1

SELECT distinct  PYRQ00,YBH000,XJID00,XJYWMC,ZWMC00,XJJG00,BBBZ00,JGZT00,XJMS00,JLS000,decode(SFDCNY,'Y','是','否') SFDCNY
 FROM VW_JY_XJJG00 WHERE YBH000='004369' AND PYRQ00='20230418'
SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 004369


 select rownum,JG.* from (select B.XH0000,B.ZWMC00,B.MCSX00,a.YMJG00,a.YMJGKB,a.YMSM00,a.JGBZ00,a.bgjgid,A.KSSID0,A.XJJG00,B.ZWMC00 as KSSMC0 from JY_XJBGJG a,JY_KSSZD0 B where B.KSSID0=A.KSSID0  AND XJID00='5700' AND YBH000='004369'  AND PYRQ00='20230418' ORDER BY XH0000) JG 

SELECT DISTINCT LCPY00,ZJPY00,BZ0000 FROM JY_XJJGPY  WHERE YBH000='004369'  AND PYRQ00='20230418'




SELECT * FROM VW_JY_JYJG00  WHERE ybh000='004369' and pyrq00='20230418'
 ORDER BY DYSX00
在检验结果查询未控的情况下，查询下面细菌表结果进行展示

细菌结果取值情况（查询语句与界面对应字段内容）
SELECT distinct  PYRQ00,YBH000,XJID00,XJYWMC,ZWMC00,XJJG00,BBBZ00,JGZT00,XJMS00,JLS000,decode(SFDCNY,'Y','是','否') SFDCNY
 FROM VW_JY_XJJG00 WHERE YBH000='004369' AND PYRQ00='20230418'
1、标本鉴定结果：VW_JY_XJJG00（ZWMC00，XJJG00，XJMS00，JLS000，SFDCNY）
2、标本评语：VW_JY_XJJG00（BBBZ00）

 select rownum,JG.* from (select B.XH0000,B.ZWMC00,B.MCSX00,a.YMJG00,a.YMJGKB,a.YMSM00,a.JGBZ00,a.bgjgid,A.KSSID0,A.XJJG00,B.ZWMC00 as KSSMC0 from JY_XJBGJG a,JY_KSSZD0 B where B.KSSID0=A.KSSID0  AND XJID00='5700' AND YBH000='004369'  AND PYRQ00='20230418' ORDER BY XH0000) JG 
3、药敏结果：JG（ZWMC00，YMJG00，YMJGKB，YMSM00）

SELECT DISTINCT LCPY00,ZJPY00,BZ0000 FROM JY_XJJGPY  WHERE YBH000='004369'  AND PYRQ00='20230418'
4、专家评语：XJJGPY（ZJPY00）