Query for list of people who designated to a program and have an email address

select PE.NamePrefix,
 PE.FirstName,
 PE.MiddleName,
 PE.LastName,
 PE.NameSuffix,
 PE.Salutation,
 EM.EmailAddress,
 YE.YearDesc,
 AP.AppealDesc,
 PL.PledgeAmount,
 PR.ProgramDesc,
 DE.DesignationAmount
from camPledges PL,
 camAppeals AP,
 camYears YE,
 camDesignations DE,
 camPrograms PR,
 camPeople PE,
 camEmails EM
where PL.AppealID = AP.AppealID
 and AP.YearID = YE.YearID
 and PL.PledgeID = DE.PledgeID
 and DE.ProgramID = PR.ProgramID
 and PL.NameID = PE.NameID
 and PL.NameID = EM.NameID
 and EM.PrimaryEmail = 'Y'