title: SQL Getting Specific Column other than just the foreign key
body: <p>I have sql table called Games as follows:</p>
  
  <pre><code>CREATE TABLE Games
  (date date NOT NULL,
  ho_t_id varchar(9) NOT NULL,
  v_t_id varchar(9) NOT NULL,
  h_score int,
  v_score int,
  
  PRIMARY KEY(date, ho_t_id, v_t_id),
  FOREIGN KEY(ho_t_id) REFERENCES Team ON UPDATE CASCADE,
  FOREIGN KEY(v_t_id) REFERENCES Team);
  </code></pre>
  
  <p>As you can see, it has two foreign keys to a table called Team. The ho_t_id and v_t_id reference to the primary key of the Team table called t_id.</p>
  
  <p>I would like to show all the columns of the Games table (*) but replace the ho_t_id by the name of the team which exist in the Team table. (The Team table contains a column named Name).</p>
  
  <p>How can I do that?</p>