Add a second copy of tbl_People:
FROM (tbl_people As Claimant INNER JOIN tbl_mediation_log
ON Claimaint.PeopleID = tbl_mediation_log.Claimant_Petitioner_Name_ID)
INNER JOIN tbl_People AS Respondent
ON Respondent.PeopleID = tbl_mediation_log.RespondentID
Note that I gave each copy of tbl_people an alias name so that you can tell which is which.
BTW, in your list of fields below, you say it's ClaimantID, but you use Claimant_Petitioner_Name_ID in your SQL. Have no clue what is the actual name for "RespondentID" in tbl_Mediation_log.
John Viescas, Author
Microsoft Access 2010 Inside Out
Microsoft Access 2007 Inside Out
Microsoft Access 2003 Inside Out
Building Microsoft Access Applications
SQL Queries for Mere Mortals
On Apr 28, 2016, at 7:42 AM, firstname.lastname@example.org [MS_Access_Professionals] <MS_Access_Professionals@yahoogroups.com> wrote:
Posted by: John Viescas <email@example.com>
|Reply via web post||•||Reply to sender||•||Reply to group||•||Start a New Topic||•||Messages in this topic (2)|