SELECT SELECT VALUE FROM PT_INPATIENT_CURE CU RCD_INPATIENT_RECORD_SET C RCD_INPATIENT_RECORD B RCD_RECORD_ITEM OI VHIS_INPATIENTINFO A WHERE CINPATIENT_ID = CUID

可以使用字符串拼接函数concat()将两个字段拼接成一个字段：

SELECT CONCAT( (SELECT VALUE FROM PT_INPATIENT_CURE CU, RCD_INPATIENT_RECORD_SET C, RCD_INPATIENT_RECORD B, RCD_RECORD_ITEM OI, VHIS_INPATIENTINFO A WHERE C.INPATIENT_ID = CU.ID AND B.INPATIENT_RECORD_SET_ID = C.ID AND OI.INPATIENT_RECORD = B.ID AND B.RECORD_CHILD_TYPE = 'In_Record' AND A.INPATIENT_NO = T.CLINICNO AND a.id=CU.Id AND OI.ELEMENT_ID IN ('201') AND ROWNUM='1' ), (SELECT VALUE FROM PT_INPATIENT_CURE CU, RCD_INPATIENT_RECORD_SET C, RCD_INPATIENT_RECORD B, RCD_RECORD_ITEM OI, VHIS_INPATIENTINFO A WHERE C.INPATIENT_ID = CU.ID AND B.INPATIENT_RECORD_SET_ID = C.ID AND OI.INPATIENT_RECORD = B.ID AND B.RECORD_CHILD_TYPE = 'In_Record' AND A.INPATIENT_NO = T.CLINICNO AND a.id=CU.Id AND OI.ELEMENT_ID IN ('59') AND ROWNUM='1' ) ) AS ILLNESS_HISTORY 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