title: How to get name from another table when using a key in SELECT?
body: <p>I know this may be an easy question, but I've been stumped on this for the past hour and am not sure what terms to lookup that accurately describe what I am trying to do.</p>
  
  <p>I have a MySQL database with two tables. Countries and Regions. The Regions table has two columns, id and name. An example of a row would be 1, north-america.</p>
  
  <p>In the Countries table, there's a column named RegionID that would have a 1 if the country's region is north-america.</p>
  
  <p>How can I grab the "north-america" in my query instead of printing out "1"?</p>
  
  <p>Here's my SELECT that I am stumped on:</p>
  
  <pre><code>SELECT A.name, A.regionID FROM countries A, regions B ORDER BY A.name ASC
  </code></pre>