I have 2 tables in SQL Server:

![enter image description here](https://i.stack.imgur.com/vGx63.jpg)

Now I want to write a select statement to join these 2 tables to get `MatchId`, `Host name` and `Guest name`.

What I tried:

```
select Match.Id, Team.Name, Team.Name 
from Match 
join Team on Match.HostId = Team.Id

```

and I got host name and guest name are the same.

```
select Match.Id, Team.Name, Team.Name 
from Match 
join Team on Match.HostId = Team.Id 
join Team on Match.GuestId = Team.Id

```

I got error.

Please help!