Hi Dennis,

Try this:

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.iPeopleID

Note 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.