title: Join 2 tables to get 2 related records Mysql PHP
body: <p>I have two tables like so:</p>
  
  <pre><code># Match 
  id, team1_id , team2_id
  -----------------------
  1, 10, 20
  2, 10, 50
  
  
  
  # Team 
  id, team_name, team_country
  ---------------------------
  10, team A , England
  20, team B , France 
  </code></pre>
  
  <p>I'm trying to get the list from Match table with both teams info, 
  I wanna some thing like :</p>
  
  <pre><code>Team A (England)  vs Team B (France)
  </code></pre>
  
  <p>I tried this one, but I got false team info, some thing wrong with my query for sure.</p>
  
  <p>Here's my query :</p>
  
  <pre><code>  SELECT `match`.*,
    `t1`.`team_country` as team1_country,
    `t2`.`team_country` as team2_country
    FROM `match`,
    `team` t1 , `team` t2
    WHERE `match`.`team1_id` = `t1`.`id` and `match`.`team2_id` = `t2`.`id`
  </code></pre>
  
  <p>Thanks in advance!</p>