我有两个表,一个包含下一个
___________________________________
|| Hospital Table ||
||_______________________________||
|| Hospital_no || Hospital_name ||
|| ||
和另一个
___________________________________
|| Doctor Table ||
||_______________________________||
|| Doctor_no || Hospital_no ||
|| ||
哪位doctor.Hospital_no与Hospital.Hospital_no相关联,但我无法获得
______________________________________________________
|| Hospital_name | number of doctors in the hospital
|| ||
我怎样才能做到这一点
试试这个:
select HP.Hospital_name,COUNT(DT.Doctor_no) as
NoOfDoctors
from HospitalTable HP
Left join DoctorTable DT
ON HP.Hospital_no=DT.Doctor_no
GROUP BY HP.Hospital_name
本文收集自互联网,转载请注明来源。
如有侵权,请联系[email protected] 删除。
我来说两句