title: nested "select " query in mysql
body: <p>hi i am executing nested "select" query in mysql .
  the query is </p>
  
  <pre><code>SELECT `btitle` FROM `backlog` WHERE `bid` in (SELECT  `abacklog_id`  FROM `asprint` WHERE `aid`=184 )
  </code></pre>
  
  <p>I am not getting expected answer by the above query. If I execute:</p>
  
  <p>SELECT  <code>abacklog_id</code>  FROM <code>asprint</code> WHERE <code>aid</code>=184</p>
  
  <p>separately </p>
  
  <p>I will get abacklog_id as <code>42,43,44,45</code>;</p>
  
  <p>So if again I execute:</p>
  
  <pre><code>SELECT `btitle` FROM `backlog` WHERE `bid` in(42,43,44,45)
  </code></pre>
  
  <p>I will get btitle as    <code>scrum1 scrum2 scrum3 msoffice</code></p>
  
  <p>But if I combine those queries I  will get only <code>scrum1</code> remaining  3 <code>atitle</code> will not get.</p>