Just to add, if there are cases that don't (yet) have a Loan, Rep or Debtor assigned then you can use LEFT JOIN to get all cases, even if their data is not complete.

>Try

SELECT cases.StartDate,
>		reps.PersonsName AS RepName,
>		Debtors.PersonsName AS DebtorName
>	FROM CASES
>		JOIN LOANS ON loans.iLoanID = cases.iLoanID
>		JOIN PEOPLE Reps ON Reps.iPeopleID = cases.iRepID
>		JOIN PEOPLE Debtors ON Debtors.iPeopleID = loans.iDebtorID
>

>>I want to write a select statement that will result in the following cursor:
>>
>>The "StartDate"
>>The "Rep's name"
>>The "Debtor's name"