title: Query to display names for values instead of IDs between 2 tables
body: <p>I have a table with the name of different sports</p>
  <p><code>Sports</code> Table</p>
  <pre><code>id   name
  ----------
  1   None
  2   Baseball
  3   Basketball
  4   Football
  </code></pre>
  <p>And another table that associated states and their sports teams, based on the level of play for each sport.</p>
  <p><code>State_Teams</code> Table</p>
  <pre><code>id state     pro_league   minor_league     amateur_league
  ----------------------------------------------------------------
  1  alabama         1           4                1
  2  alaska          1           1                1
  3  arizona         2           3                4
  4  arkansas        1           2                3
  </code></pre>
  <p>Instead of only displaying those sports IDs, I'd like to display their name. Ideally, I would create a query so that my output looks like this...</p>
  <p>Output</p>
  <pre><code>id state     pro_league   minor_league     amateur_league
  ----------------------------------------------------------------
  1  alabama        None          Football          None
  2  alaska         None          None              None
  3  arizona        Baseball      Basketball        Football
  4  arkansas       None          Baseball          Basketball
  </code></pre>
  <p>I'm having issue changing the IDs to be names for all the columns. So far, I can change the name for only one column. Any help would be much appreciated!</p>