歡迎來到梁良 | LonBlog，這里記錄下了我生活點(diǎn)點(diǎn)滴滴。
posted on 2010-04-07 22:45 梁良 閱讀(11257) 評(píng)論(3) 編輯 收藏 所屬分類: 一滴一滴
謝謝！ 回復(fù) 更多評(píng)論
SELECT DT.DOCTORNO AS DOCTORNO,DT.NAME AS DOCTORNAME,CF.HOSPITALNO AS HOSPITALNO,M.NAME AS 醫(yī)療結(jié)構(gòu),NVL(CFD.MONEY,0)-NVL(X.CRDMONEY,0) AS MONEY,NVL(CFD.ALLNUMBERS,0)-NVL(CRDALLNUMBERS,0) AS ALLNUMBERS,D.NAME AS DNAME,CF.DOCTORID AS DOCTORIDFROM CLINICFEE CFLEFT OUTER JOIN CLINICFEEDETAILS CFD ON CF.CLINICFEEID=CFD.CLINICFEEIDLEFT OUTER JOIN (SELECT NVL(CRD.MONEY,0) AS CRDMONEY,NVL(CRD.ALLNUMBERS,0) AS CRDALLNUMBERS,CR.PATIENTID AS PATIENTID,CRD.CLINICFEEDETAILSID AS CLINICFEEDETAILSID FROM CLINICRETURN CR,CLINICRETURNDETAILS CRD WHERE CR.CLINICRETURNID=CRD.CLINICRETURNID) X ON X.PATIENTID=CF.PATIENTID AND X.CLINICFEEDETAILSID=CFD.CLINICFEEDETAILSID,DRUG D,PATIENT P,DOCTOR DT,MEDICALINSTITUTION M WHERE D.DRUGID=CFD.DRUGID AND P.PATIENTID=CF.PATIENTID AND CF.DOCTORID=DT.DOCTORID AND CF.HOSPITALNO=M.HOSPITALNO AND M.HOSPITALNO=DT.HOSPITALNO 回復(fù) 更多評(píng)論
.； 回復(fù) 更多評(píng)論
Powered by: BlogJava Copyright © 梁良
Powered by: LonLeung Copyright © 梁良