摘要： 1 SELECT hp_patient.name, hp_ptorders.DrugName, hp_ptorders.Dosage,hp_ptorders.DosageUnit 2 FROM hp_patient 3 LEFT JOIN hp_ptorders 4 ON hp_patient.pid=hp_ptorders.PtId 5 ORDER BY hp_patient.name 阅读全文