title: Get result using two queries
body: <p>I have two tables: <code>tbl_mostvisitedposts</code> which has fields (id, classifiedid, city, views), <code>tbl_classifieds</code> which has fields (classifiedid, city, classifiedname).</p>
  
  <p>I want to retrieve classified name which have the most visited views. I did following but it says:</p>
  
  <blockquote>
    <p>'Subquery returns more than 1 row'</p>
  </blockquote>
  
  <p>Please help me.</p>
  
  <p>My query is:</p>
  
  <pre><code>SELECT * FROM tbl_classifieds WHERE classifiedid=(SELECT id FROM tbl_mostvisitedposts WHERE city='mumbai') LIMIT 5
  </code></pre>