查询一张表中的字段是否存在于另一张表

select a.StaffCode,a.HospitalCode from MDS_DoctorRequest a,MDS_UserHospitalProduct b
where
a.StaffCode=b.StaffCode and a.HospitalCode=b.HospitalCode