title: How to write multiple select query in mysql i.e one query is return some id's then i will write select query based on that return id's?
body: <p>This is my requirment</p>
  
  <p>i select users id based on email matching between two tables(a.b).then i will select infomation based on that users id in another table(c).</p>
  
  <pre><code>SELECT a.email, b.id
  FROM `user_fnf_info` AS a
  JOIN users AS b ON a.email = b.email
  WHERE a.user_id =1;
  </code></pre>
  
  <p>it's possible in two queries in mysql,but i need to know how to write in a single query (mysql).</p>
  
  <p>anyone help me on this requirement.thanks in advance.</p>