I have two tables `Users` and `Details`. The `UserId` is the primary key from `Users`.

On the other hand the column `UserId` from `Details` is a reference from the table `Users`.

**Table: Users**

```
UserId    FirstName    Lastname
1         John         Wick
2         Black        Panther
3         Lebron       James

```

**Table: Details**

```
UserId    ManagerId    SupervisorId
1         3            2
2         3            1
3         3            1

```

If I were to execute a query like:

```
SELECT * FROM Users INNER JOIN Details on Users.UserId = Details.UserId

```

The results would be:

**Table: Details**

```
UserId    FirstName  LastName ManagerId  SupervisorId
1         John       Wick     3          2
2         Black      Panther  3          1
3         Lebron     James    3          1

```

What I'm trying to achieve is this:

```
UserId    FirstName  LastName ManagerId  SupervisorId
1         John       Wick     Lebron     Black
2         Black      Panther  Lebron     John
3         Lebron     James    Lebron     John

```

Basically to use another column from the table of its reference key. How would I do this?