title: How to display meaningful data from multiple tables (mySQL)
body: <p>I am trying to make a query that get the information from these tables. Now by simply using <code>Select * from Kamp;</code> I get all the information I want, but as integers as that's what I have selected the columns to be in the <code>Kamp</code> Table. But that doesn't give any useful/meaningful information for people who does not know what each integer represents.</p>
  
  <p>What I am looking for is a query that gets the information from each table, connected to the integer displayed in the <code>Kamp</code> table so that I can get a complete and meaningful output on the website.</p>
  
  <p>For example:</p>
  
  <p>I want <code>Deltaker1</code> and <code>Deltaker2</code> (Participant 1 and 2) in <code>Kamp</code> to display <code>Fornavn</code> + <code>Etternavn</code> (Firstname + Lastname) from <code>Trener</code>, <code>Arena</code> in Kamp to display <code>Type</code> + <code>Adresse</code> from <code>Stadio</code>. I have tried to inner join the tables, but I still end up with the integers.</p>
  
  <p>Hope someone can help me :)</p>
  
  <p><img src="https://i.stack.imgur.com/rmPnd.png"></p>