title: MYSQL Where statement/clause being ignored
body: <pre><code>SELECT country.continent, country.name, city.district, city.name, city.population
  FROM world.country, world.city
  WHERE city.population &lt; 3000000 
  LIMIT 20, 30;
  </code></pre>
  
  <p>I'm getting a cartesian product instead of a table showing the contents of the select clause where the city population is over 3 million.</p>
  
  <p>world is the name of the database
  country and city are tables</p>
  
  <p>please help.</p>