I created a query object, named query one. Here is the SQL
Code:
SELECT R_PersonIssues.ID, R_PersonIssues.PersonID, E_Persons.LastName, E_Persons.FirstName, E_Issues.Tag
FROM E_Persons RIGHT JOIN (E_Issues RIGHT JOIN R_PersonIssues ON E_Issues.ID = R_PersonIssues.IssueID) ON E_Persons.ID = R_PersonIssues.PersonID
ORDER BY E_Persons.LastName;
I also added some entries to your junction table. I think this is what you are after. However, you may want to do some testing and consider your business rules while you try to break it.
I am uploading the DB here. I did not have an opportunity to scrutinize everything. I am working on some other stuff, here. So, be sure to ask questions.