17,377
社区成员
发帖
与我相关
我的任务
分享
SELECT DISTINCT
A.PATIENT_ID,A.VISIT_ID,B.NAME,B.INP_NO,C.ADMISSION_DATE_TIME,C.DEPT_ADMISSION_TO,C.charge_type,D.DEPT_NAME
FROM INP_BILL_DETAIL A,PAT_MASTER_INDEX B,PAT_VISIT C,DEPT_DICT D
WHERE
(A .PATIENT_ID = B.PATIENT_ID)
AND (A .PATIENT_ID = C.PATIENT_ID) AND (A .VISIT_ID = C.VISIT_ID)
AND A .RCPT_NO IS NULL
AND A .PATIENT_ID NOT IN (SELECT PATIENT_ID FROM PATS_IN_HOSPITAL)
AND SUBSTR (A .ORDERED_BY, 1, 4) = '" + ward_code + @"'
AND D.DEPT_CODE = C.DEPT_ADMISSION_TO
ORDER BY ADMISSION_DATE_TIME desc