sql联合查询多个表

 新葡亰计算机网络     |      2020-04-15

SELECT hp_patient.name, hp_ptorders.DrugName, hp_ptorders.Dosage,hp_ptorders.DosageUnit
FROM hp_patient
LEFT JOIN hp_ptorders
ON hp_patient.pid=hp_ptorders.PtId
ORDER BY hp_patient.name

上一篇:[ MySql学习心得 ] 下一篇:没有了