select t1.subject_id,t1.hadm_id,t1.icd9_code, t2.admittime,t2.dischtime,t2.deathtime,t2.insurance,t2.marital_status, t3.gender,t3.dob,t3.dod,t3.expire_flag, t4.itemid,t4.value,t4.valuenum,t4.valueuom,t4.flag, t5.label,t5.category, t6.startdate,t6.enddate,t6.drug_type,t6.drug,t6.drug_name_poe,t6.drug_name_generic from mimiciii.diagnoses_icd t1 left join mimiciii.admissions t2 on t1.hadm_id=t2.hadm_id left join mimiciii.patients t3 on t1.subject_id=t3.subject_id left join mimiciii.labevents t4 on t1.hadm_id=t4.hadm_id left join mimiciii.d_labitems t5 on t4.itemid=t5.itemid left join mimiciii.prescriptions t6 on t1.hadm_id=t6.hadm_id where t1.icd9_code in('41404','41030','41021','41042','41407') and t4.itemid in('50803','50804','50805','50806','50808','50809','50811','50813','50814','50815', '50816','50817','50818','50820','50821','50822','50824','50852','50853','50854', '50855','50861','50862','50863','50866','50867','50868','50869','50870','50878', '50882','50883','50884','50885','50889','50893','50896','50902','50904','50905', '50906','50907','50908','50909','50910','50911','50912','50915','50927','50930', '50931','50945','50947','50949','50950','50951'')如何将查询到的结果转换为每个病人一行的宽表
最新发布