Hi.
I’ve got a query output issue I'd appreciate support with.
The query (see SQL below) matches up the person’s name(PersonID) with their job role (JobTitle) and in which area they work (eitherSevenServices or WestandNorth).
This appeared to work until two people were given the samejob title of Service Director in SevenServices. While these two now show up thequery output correctly, it has gone wrong in WestandNorth where the one personwith the role of Service Director now appears twice. I suspect this is Database 101. But if anyone could point mein the right direction it would be appreciated. Been puzzling over this on andoff for a couple of days.
SELECT DISTINCT tblJobTitles.JobTitle, tblSevenServices.PersonID,tblWestandNorth.PersonID
FROM (tblJobTitles INNER JOIN tblSevenServices ONtblJobTitles.JobTitle = tblSevenServices.JobTitle) INNER JOIN tblWestandNorthON tblJobTitles.JobTitle = tblWestandNorth.JobTitle;