Select ; Cases.StartDate, ; P1.PersonName As RepName, ; P2.PersonName As DebtorName ; From ; Cases ; Left Join People As P1 On Cases.iRepID = P1.iPeopleID ; Left Join Loans On Cases.iLoanID = Loans.iLoanID ; Left Join People As P2 On Loans.iDebtorID = P2.iPeopleIDNote that I have used left joins. This gets all Cases, even if there aren't matching Loans and People. If you want only those cases that have complete information then use Inner where I have used Left.