You can use the following code for this, it will do the magic for you:
Events.EventName AS EventName,
EventsLocation.LocationName AS LocationName
INNER JOIN EventsLocation ON Events.Location=EventsLocation.Location
Want to get certified in SQL? Register for this complete SQL Course by Intellipaat.
Watch this video tutorial on how to become a professional in SQL.