SQL query that returns value based on lookup of id in another table

SELECT
  Events.EventName AS EventName,
  EventsLocation.LocationName AS LocationName
FROM
  Events
  INNER JOIN EventsLocation ON Events.Location=EventsLocation.Location
(WHERE ...)
;

Join the tables:

select e.EventName, l.LocationName
from Events e
inner join EventsLocation l on l.Location = e.Location