title: SQL Replace multiple variables from another table in query result
body: <p>I have a team schedule table that looks like this:</p>
  
  <p>DBO.SCHEDULE</p>
  
  <pre><code>Game1_Time  |  Game1_Home_Team   | Game1_Away_Team 
  ===================================================
  12:00:00    |         1          |         2
  </code></pre>
  
  <p>I want to replace the team values with their corresponding team that exists in another table:</p>
  
  <p>DBO.TEAM</p>
  
  <pre><code>Team_Number  |  Team_Name
  ========================
      1        |  The Monsters
      2        |  Bug Bites
  </code></pre>
  
  <p>TRYING TO DO THIS:
  How do I replace the 1 &amp; 2 in Schedule with "The Monsters" &amp; "Bug Bites" in a query result? </p>
  
  <pre><code>Game1_Time  |  Home Team         | Away Team 
  ===================================================
  12:00:00    |  The Monsters      |  Bug Bites
  </code></pre>