I have the following SQL Query. I want to return ONLY the records where the join only returns 1 record from the CompanySentResume table.
Select Company.CompanyID as CompanyID, Name,Email, SentResumeDate as "Resume Sent Date", FirstName From Company
LEFT JOIN CompanySentResume
ON Company.CompanyID = CompanySentResume.CompanyID
Where InvalidEmail = 0 AND DoNotContact ='0'
Order by SentResumeDate, CompanyID