27      12:57:37  SQL Execute: ORACLE - select a.gxid00,a.zlxmid,a.sfxmid,c.xmmc00,a.gdbz00,a.BQSFBZ,a.bz0000,a.FJFYBZ,a.sfcs00,a.mxxmid,a.JSXZ00, C.SFJE00,A.GJBM00,a.TYBZ00,a.SFLB00,C.DW0000,c.BH0000,(SELECT YPBM00 FROM (SELECT A.SFXMID,MAX(B.YPBM00) YPBM00 FROM BM_WZQTXX A,BM_YD0000 B WHERE A.YPNM00 = B.YPNM00 GROUP BY A.SFXMID) D WHERE D.SFXMID = C.SFXMID) YPBM00  ,(SELECT DISTINCT YPMC00 FROM (SELECT A.SFXMID,B.YPMC00,MAX(B.YPBM00) YPBM00 FROM BM_WZQTXX A,BM_YD0000 B WHERE A.YPNM00 = B.YPNM00 GROUP BY A.SFXMID,B.YPMC00) D WHERE D.SFXMID = C.SFXMID) YPMC00  from XT_ZLSFGX a,BM_ZLZD00 B,BM_YYSFXM C where a.zlxmid=b.zlxmid and a.sfxmid=c.sfxmid and B.ZLXMID=34164  order by xmmc00

28      12:57:37  SQL Error: ORACLE - ORA-01427: 单行子查询返回多个行





--其中
SELECT DISTINCT YPMC00 FROM (SELECT A.SFXMID,B.YPMC00,MAX(B.YPBM00) YPBM00 FROM BM_WZQTXX A,BM_YD0000 B WHERE A.YPNM00 = B.YPNM00 GROUP BY A.SFXMID,B.YPMC00) D WHERE D.SFXMID = C.SFXMID

语句的返回结果有两条，即一个收费耗材对应两个物资耗材目录，一个为停用状态，另一个为在用状态