SQL查询，根据另一个表中的id查找返回值

I have 2 tables:

我有2张桌子:

    dbo.Events

    EventID               EventName            Location
    1                     Birthday Party       2
    2                     Wedding              1

    dbo.EventsLocation

    Location    LocationName
    1           Room 1
    2           Room 2
    dbo.Events