(MySQL) I have two tables:

```
|------------|      |------------|
| LOANS      |      |PEOPLE      |
|------------|      |------------|
|lenderID    |      |personID    |
|borrowerID  |      |firstName   |
|LibrarianID |      |lastname    |
|------------|      |------------|

```

In the loans table, everyone of those fields refers to a matching personID in the PEOPLE table. 

What I'm looking for is a single SQL query statement something like

```
SELECT
   CONCAT(firstName, " ", lastname) as TheLender,
   CONCAT(firstName, " ", lastname) as TheBorrower,
   CONCAT(firstName, " ", lastname) as TheLibrarian,
FROM
   ...
WHERE   
   ...

```

I can't workout how to get all three names in a single result. How do I iterate through three links, firstly on lenderID = personID, then borrowerID = personId, and then librarianID=personID.... all in one go?