How do I pull only one occurence w/query?

[manning_news]

Using A2003. I have a one-to-many relationship between a doctor table
and a table of their specialties. A doctor can have many specialties.
How do I pull doctors whose one and only specialty is "Internal
Medicine"?

Thanks for any help or advice.

[manning_news]

Think I got it.

SELECT tblFaculty.LastName, tblSpecialties.ID, tblSpecialties.Specialty
FROM tblFaculty INNER JOIN tblSpecialties ON tblFaculty.ID =
tblSpecialties.ID
WHERE (((tblSpecialties.ID) In (SELECT [ID] FROM [tblSpecialties] As
Tmp GROUP BY [ID] HAVING Count(*)=1 )) AND
((tblSpecialties.Specialty)="internal medicine"))
ORDER BY tblSpecialties.ID;