SELECT hp_patient.name, hp_ptorders.DrugName, hp_ptorders.Dosage,hp_ptorders.DosageUnitFROM hp_patientLEFT JOIN hp_ptordersON hp_patient.pid=hp_ptorders.PtIdORDER BY hp_patient.name
sql联合查询多个表
原文：http://www.cnblogs.com/terminator404/p/5110659.html
