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?