Elegant.

I notice it took you 7 minutes to reply to Dennis. Are you ill? ;-)



>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 have the following table structure:
>>
>>CASES - iCaseID, iRepID, iLoanID, startDate
>>
>>LOANS - iLoanID, iDebtorID
>>
>>PEOPLE - iPeopleID, PersonsName
>>
>>iRepID and iDebtorID would equal two different iPeopleIDs in the PEOPLE table.
>>
>>I want to write a select statement that will result in the following cursor:
>>
>>The "StartDate"
>>The "Rep's name"
>>The "Debtor's name"
>>
>>How would I write this?