title: Get name from another table using an ID
body: <p>I've got two tables, one is called <code>matches</code> and the other one is called <code>teams</code>. <code>matches</code> only list team IDs, but I want my query to include team names from <code>teams</code>. I tried different solutions already and I came up with this query, but it didn't work:</p>
  
  <pre class="lang-sql prettyprint-override"><code>SELECT *  FROM `matches` WHERE `mWeek` = 1
  INNER JOIN `teams`.`tName` ON `matches`.`tHome` = `teams`.`tId`
  </code></pre>
  
  <p>That query returned error #1064. I'm happy to provide more details if necessary.</p>