SELECT other columns,tmp.EmailAddress
FROM Responders
INNER JOIN tblCategory ON Responders.CategoryID = tblCategory.CategoryID
LEFT OUTER JOIN tblLocation
INNER JOIN tblOrganisation ON tblLocation.OrganisationID = tblOrganisation.OrganisationID ON Responders.LocConID = tblLocation.LocationID
LEFT OUTER JOIN tblContact ON Responders.ContactID = tblContact.ContactID
LEFT OUTER JOIN ResponderNotes ON Responders.CRID = ResponderNotes.CRID
LEFT OUTER JOIN tblContactLocation ON Responders.ContactID = tblContactLocation.ContactID AND Responders.LocConID = tblContactLocation.LocationID
LEFT OUTER JOIN 
(
SELECT ContactID,MAX(Info) AS EmailAddress
FROM tblResponderExtraInfo 
INNER JOIN tblResponderExtraInfoType 
ON tblResponderExtraInfo.TypeID = tblResponderExtraInfoType.TypeID
AND tblResponderExtraInfoType.Type = 'Email'
GROUP BY ContactID) tmp
ON Responders.ContactID = tmp.ContactID

quote:

---

Originally posted by Webskater

Thank you VERY MUCH!

That worked perfectly. I had spent hours doing things like that - but, unfortunately, had reached the end of my limited brain power.

Thanks again.

---