title: MySQL - JOIN 2 tables with 2 ID's in common
body: <p>I have 2 tables that I need to get information from, and would like to get the information in one single query.</p>
  
  <p>The situation is this :</p>
  
  <pre><code>table "matches" :
  
  id
  team_A_id
  team_B_id
  
  table "teams" :
  
  id
  name
  </code></pre>
  
  <p>The objective is to retrieve information from table "matches" (football matches) and join the information with the table "teams". I need this because my webservice provider doesn't have the xml data in my language (portuguese), and so I need to offer my client the option to translate certain team names to portuguese, otherwise I'd add the team names directly on the "matches" table. The problem is that I need to JOIN the 2 tables with 2 id's. I know how to join tables with 1 id in common, but can't figure out how to do it with 2 id's, and mantaining the information from the 2 teams involved in each match intact.</p>
  
  <p>Is this possible? Or do I have to create separate queries?</p>