title: MySQL Inner Join Between Two Tables
body: <p>I'm trying to JOIN two tables in <code>MySQL</code>. Here is my table:</p>
  
  <p><strong>Games Table</strong>:</p>
  
  <pre><code>GameID      Date/Time          PlayerOneID   PlayerTwoID
   13    12/10/2013 10:53:29 PM     1              2    
   14    12/10/2013 10:57:29 PM     1              2
   15    12/10/2013 10:58:29 PM     2              1
  </code></pre>
  
  <p>I have another table contain the ID of a player and that players name.</p>
  
  <p><strong>Players Table</strong>:</p>
  
  <pre><code>1   Dan
  2   Jon
  </code></pre>
  
  <p>I'd like the resulting table to look like the following:</p>
  
  <pre><code>GameID      Date/Time          PlayerOneID   PlayerTwoID
   13    12/10/2013 10:53:29 PM     Dan        Jon      
   14    12/10/2013 10:57:29 PM     Dan        Jon
   15    12/10/2013 10:58:29 PM     Jon        Dan
  </code></pre>
  
  <p>Here's what I am currently doing:</p>
  
  <pre><code>SELECT Games.GameID, Games.`Date/Time`, Players.Name, PlayerTwoID
  FROM Games
  
  INNER JOIN Players
  ON PlayerOneID = Players.ID
  </code></pre>
  
  <p>This gets PlayerOnes name, but I can't find away to get PlayerTwos name as well. I have tried using two INNER JOINS, but this hasn't worked. I've read a lot of posts here on the stack, but I haven't come across any solution that works. I am new to MySQL, so a follow up explanation would be very helpful.</p>