title: SQL - Inner join on two columns from table 1 with one column from table 2?
body: <p>I have a table that has two columns that each contain a member id that is a foreign key to a members table that contains their name. I want to select the first table with names instead of member IDs. I'm not sure of a way to do this. I feel like there's certainly a way involving an INNER JOIN, but I can't think of how to pick two names from one table in one INNER JOIN. Any ideas?</p>
  
  <p>Thanks in advance!</p>
  
  <p>Match table</p>
  
  <pre><code>|------|-------|
  | user | match |
  |------|-------|
  | 1    | 4     |
  | 2    | 1     |
  | 3    | 2     |
  |------|-------|
  </code></pre>
  
  <p>Members table</p>
  
  <pre><code>|------|-------|
  | user | name  |
  |------|-------|
  | 1    | Joe   |
  | 2    | Kyle  |
  | 3    | John  |
  | 4    | Nate  |
  |------|-------|
  </code></pre>
  
  <p>Desired output</p>
  
  <pre><code>|------|-------|
  | user | match |
  |------|-------|
  | Joe  | Nate  |
  | Kyle | Joe   |
  | John | Kyle  |
  |------|-------|
  </code></pre>