SQL 查询：获取患者手术信息

SELECT po.INPAT_NUM AS 'inpatNum', BEF_DIAG_ID AS 'DIAG_BEFORE_OPERATION', (SELECT data_value_remark FROM sysmn.mav_emr_core_dict WHERE basicdatavalue_id = DISEASE_RESULT) AS 'PATIENT_CONDITION', SCHEDULED_DATE_TIME AS 'SCHEDULED_DATE_TIME', dd.dept_name AS 'OPERATIONG_ROOM', SEQUENCE AS 'SEQUENCE', (SELECT data_value_remark FROM sysmn.mav_emr_core_dict WHERE basicdatavalue_id = QUARANTINE_FLAG) AS 'ISOLATION_INDICATOR', SPECIAL_SURGERY AS 'SPECIL_OPERATION', dd.dept_name AS 'OPERATING_DEPT', OPER_PERSON_ID AS 'SURGEON_EMP_NO_STAMP', (SELECT person_name FROM sysmn.ehr_service_personal WHERE person_id = OPER_PERSON_ID) AS 'SURGEON_EMP_NO', (SELECT person_name FROM sysmn.ehr_service_personal WHERE person_id = ASS_I_PERSON_ID) AS 'FIRST_ASSISTANT_NO', (SELECT person_name FROM sysmn.ehr_service_personal WHERE person_id = ASS_II_PERSON_ID) AS 'SECOND_ASSISTANT_NO', (SELECT person_name FROM sysmn.ehr_service_personal WHERE person_id = ASS_III_PERSON_ID) AS 'THIRD_ASSISTANT_NO', (SELECT person_name FROM sysmn.ehr_service_personal WHERE person_id = ASS_IV_PERSON_ID) AS 'FOURTH_ASSISTANT_NO', ANAES_DOCTOR_PERSON_ID AS 'ABESTHESIA_DOCTOR_NO_STAMP', (SELECT person_name FROM sysmn.ehr_service_personal WHERE person_id = ANAES_DOCTOR_PERSON_ID) AS 'ABESTHESIA_DOCTOR_NO', (SELECT data_value_remark FROM sysmn.mav_emr_core_dict WHERE basicdatavalue_id = ANESTHETIC_ID) AS 'ANESTHESIA_METHOD', PREOPERATIVE AS 'NOTES_NO_OPERATION', ii.DATA_VALUE_REMARK AS 'operNames', REQ_DATE_TIME AS 'REQ_DATE_TIME', (SELECT person_name FROM sysmn.ehr_service_personal WHERE person_id = REQ_DOCTOR_ID) AS 'ENTERED_BY', REQ_DOCTOR_ID AS 'ENTERED_BY_STAMP', EXAM_ADVICE AS 'EXAMINE_MIND', EXAMINE_EMP_NO AS 'EXAMINE_EMP_NO', (SELECT person_name FROM sysmn.ehr_service_personal WHERE person_id = EXAMINE_EMP_NO) AS 'EXAMINE_EMP_NO_STAMP' FROM emr.patient_operation po LEFT JOIN emr.patient_operation_item poi ON po.req_num = poi.req_num LEFT JOIN sysmn.ITEM_INFO ii ON ii.BASICDATAVALUE_ID = poi.oper_item_id LEFT JOIN sysmn.sys_dept_dict dd ON dd.dept_id = po.OPERATING_ROOM