title: SQL query that returns value based on lookup of id in another table
body: <p>I have 2 tables:</p>
  
  <pre><code>    dbo.Events
  
      EventID               EventName            Location
      1                     Birthday Party       2
      2                     Wedding              1
  
      dbo.EventsLocation
  
      Location    LocationName
      1           Room 1
      2           Room 2
  </code></pre>
  
  <p>I would like to make an SQL query that returns the following</p>
  
  <pre><code>    Birthday Party    Room 2
      Wedding           Room 1
  </code></pre>