title: Having trouble using join function in SQL
body: <p>I'm trying to join two tables using the join function.</p>
  
  <p>Workbench keeps coming up with an error and don't understand why.</p>
  
  <p>Please help</p>
  
  <pre><code>select city, cityid, countryid
  from cities 
  join countries on cities.CountryID = countries.CountryID;
  </code></pre>