select a.INPATIENT_NO,a.VISIT_TIMES,a.Account_Type, 0 PublicLimit,0 THISUPLIMIT,0 as StartFee, a.ENTER_DEPT as EnterDeptId, (select dept_name from sys_dept where dept_id=a.ENTER_DEPT) as Enter_Dept_Name, a.out_dept as out_deptID,(select dept_name from sys_dept where dept_id=a.out_dept) as out_deptName,a.OUT_ROOM as out_Bed, a.NAME as Pat_Name,a.ENTER_TIME,a.OUT_TIME,a.BED_TEXT, d.ybcode as Doctor_Id, (select p.USER_NAME from sys_user p where p.USER_ID=a.attending_id) as Doctor_Name, a.OUT_DOCTOR as Out_Doctor_Id, (select p.USER_NAME from sys_user p where p.USER_ID = a.OUT_DOCTOR) as Out_Doctor_Name,b.dx_name,b.dx_code, e.yb_name as MainDiseaseName,e.yb_code as MainDiseaseNo, a.CONTACTS_NAME,a.CONTACTS_PHONE, a.WARD_ID,(select WARD_NAME from sys_ward p where p.WARD_ID = a.WARD_ID) as WARD_NAME,a.UNIT_ID,a.Sex,a.IDNUMBER from cis_inpatient a left join cis_inpat_curinf@sj_cis b on a.visit_id=b.visit_id left join CIS_ENTERORDER@Sj_Cis c on a.VISIT_ID=c.in_visit_id and c.deleted_mark=0 left join dict_icdx_disprop@sj_dict e on c.diagno_sist1 =e.main_code left join ybgl_ybdoctorregist d on a.attending_id=d.userid where a.VISIT_ID='006002-5356'
