title: Multiple MySQL columns linking to same reference table
body: <p>I am a front-end developer that needs a quick pointer for data that I am trying to get from a MySQL database.</p>
  
  <p>There is a table 'events' which includes multiple columns, including 'host_country' and 'visiting_country' (events.host_country &amp; events.visiting country). Both of these columns contain numbers to refer to various countries, the values of which are stored in a 'countries' table.</p>
  
  <p>The 'countries' table has two columns: 'countries.id' and 'countries.name'. I need to display the name of both the visiting and host countries.</p>
  
  <p>I can get one of the 'event' columns to work with a join, but it doesn't seem feasible to use two joins on the same 'countries' table. </p>
  
  <p>Is there any way to use the 'countries' table to get the names for both events.visiting_country and events.host_country?</p>
  
  <p>Thank you!
  Matt</p>