sql联合查询多个表

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

 

转载于:https://www.cnblogs.com/terminator404/p/5110659.html