title: MySQL Join Table on three columns
body: <p>I've got two tables </p>
  
  <p>The first has user transactions:</p>
  
  <pre><code>Date    Transaction    P1    P2    P3    P4    P5
  </code></pre>
  
  <p>(P1-P5 are three digit user ID's)
  Each transaction has 1, 2, 3, 4, and sometimes 5 users associated with it.</p>
  
  <p>The second table has the user info:</p>
  
  <pre><code>ID    NAME    ACTIVE
  </code></pre>
  
  <p>I'm used to using a JOIN to display the user's NAMES as opposed to their ID, but with FIVE users, I have no idea how do display their names in my PHP/HTML table.</p>
  
  <p>Would anyone be able to shed some light on this?</p>