SELECT VALUE AS 现病史 FROM PT_INPATIENT_CURE RCD_INPATIENT_RECORD_SET RCD_INPATIENT_RECORD RCD_RECORD_ITEM WHERE RCD_INPATIENT_RECORD_SETINPATIENT_ID = PT_INPATIENT_CUREID AND RCD_

可以将以上SQL查询结果作为一个子查询，并使用别名引用该子查询结果，例如：

SELECT B.COMB_ID AS DIAGID, --申请单号 '2' AS PATIENTTYPEID, --患者就诊类别，1:门诊，2：住院 T.CARDNO AS HISPATIENTID, -- 医联卡号,或患者唯一标识号 T.CLINICNO AS ENETPATIENTID, --门诊号或住院号 A.MCARD_NO AS SOCIETYID, --医保号 -- A.NAME AS PATIENTNAME, --姓名 DECODE(C.VIP_FLAG, '5', C.NORMALNAME, C.NAME) AS PATIENTNAME, --姓名 DECODE(A.SEX_CODE, 'M', '男', 'F', '女', '未知') AS SEX, --性别 A.BIRTHDAY AS BIRTHDAY, --生日 A.IDENNO AS IDNUMBER, --身份证号码 A.HOME_TEL AS PHONENUMBER, --电话号码 FUNC_STRING_CLEAN(A.HOME) AS ADDRESS, --地址 A.NATION_CODE AS FOLK, --民族 A.COUN_CODE AS NATIONALITY, --国籍 SUBSTR(A.BED_NO, 5) AS SICKBED, --病床号 T.DIAGNOSE || '【' || M.ITEM_NAME || '】' AS DIAGNOSE, --临床诊断 T.SQDOPERTIME AS STUDYTIME, --申请检查时间 A.DEPT_NAME AS REQDEPARTMENTNAME, --申请科室名称 FUN_GET_EMPLOYEE_NAME(T.DOCTCODE) AS REQDOCTOR, --申请医生名称 A.DEPT_NAME AS SICKROOM, --病房名称 NVL(M.DEVICE_NAME, DECODE(FUN_GET_DEVICENAME(M.ITEM_CODE), '超声', DECODE(T.EXECDEPTCODE, '5039', '心脏超声', '7692', '心脏超声', FUN_GET_DEVICENAME(M.ITEM_CODE)), FUN_GET_DEVICENAME(M.ITEM_CODE))) AS DEVICETYPENAME, --设备类型名称 '昆明医科大学第一附属医院' AS REQHOSPITAL, --申请医院 -- T.HISTORY AS ABSTRACTHISTORY, --病史 (SELECT VALUE FROM PT_INPATIENT_CURE , RCD_INPATIENT_RECORD_SET, RCD_INPATIENT_RECORD, RCD_RECORD_ITEM WHERE RCD_INPATIENT_RECORD_SET.INPATIENT_ID = PT_INPATIENT_CURE.ID AND RCD_INPATIENT_RECORD.INPATIENT_RECORD_SET_ID = RCD_INPATIENT_RECORD_SET.ID AND RCD_RECORD_ITEM.INPATIENT_RECORD = RCD_INPATIENT_RECORD.ID AND RCD_INPATIENT_RECORD.RECORD_CHILD_TYPE = 'In_Record' AND PT_INPATIENT_CURE.ID = 1137687 AND RCD_RECORD_ITEM.ELEMENT_ID IN ('201') AND ROWNUM='1') AS ABSTRACTHISTORY, --主诉+病史 '0' AS ISWORRY, --是否急诊 0:普通，1：急诊 '' AS ISFEE, --是否缴费 0:没有缴费，1：已经缴费 '' AS REMARK, --注意事项 DECODE(T.LBFEE, '0', (SELECT TO_CHAR(UD.UNIT_PRICE) FROM ORDT_UNDRUG UD WHERE UD.ID = M.ITEM_CODE AND ROWNUM = 1), T.LBFEE) AS STUDYFEE, --费用 T.SQDOPERTIME AS OPERATORTIME, --开单时间 T.ISPACS AS ISPACS, '' AS ITYPE, '' AS OTHERPATIENTID, '' AS EMAIL, M.ITEM_NAME AS HISCHECKITEM, NVL(M.TYPE_NAME, FUN_GET_POSITIONNAME(M.ITEM_CODE)) AS POSITIONNAME, FUN_GET_CHECKNAME(M.ITEM_CODE) AS CHECKITEMNAME, B.ID ORDERID, (SELECT A.EMPI FROM COM_PATIENTINFO A WHERE A.CARD_NO = T.CARDNO AND ROWNUM = 1) AS EMPI, --EMPI DECODE(C.VIP_FLAG, '5', '1', '0') VIP FROM PACSLIS_SQD_RECORD T, PACSLIS_SQD_RECORD_DETAILNEW M, FIN_IPR_INMAININFO A, ORD_IPM_ORDER B, COM_PATIENTINFO C WHERE T.SQDID = M.SQDID AND A.CARD_NO = C.CARD_NO AND C.IS_VALID = 1 AND T.CLINICNO = A.INPATIENT_NO AND A.INPATIENT_NO = B.INPATIENT_NO AND M.ITEM_CODE = B.TERM_CODE AND T.SQDID = FUN_SPLITSTRING(B.REQUISITION_NO, '|', 1) AND (T.SQDTYPE = 'UC' OR T.EXECDEPTCODE = '6009') AND T.ISPACS = '0' AND B.IPM_TYPE_ID = 23 AND B.STATE IN ('3', '5') --只传 临时医嘱 AND T.SQDOPERTIME > SYSDATE - 30