select poINPAT_NUM AS inpatNumBEF_DIAG_ID as DIAG_BEFORE_OPERATIONselect data_value_remark from sysmnmav_emr_core_dict where basicdatavalue_id = DISEASE_RESULT as PATIENT_CONDITIONSCHEDULED_DATE_TIME

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_ROO