select Patient from
(
select DISTINCT Patient,Hospital from DoctorWorksAt t1 left join DoctorSeesPatient t2 on t1.Doctor=t2.Doctor) tt
group by Patient having count(Hospital)=(SELECT COUNT(*) FROM (SELECT DISTINCT Hospital FROM dbo. DoctorWorksAt) tt)
温馨提示:答案为网友推荐,仅供参考