title: How to resolve subquery return more then one row
body: <p>i have three tables in database in which the first table consist of freelancer section second table of client and 3 in which when client selects an freelancer the 3 table store id of freelancer and id of client. but when i want to retreive the information of freelancer selected by client it shows the error mentioned above in heading
  here is my query</p>
  
  <pre><code>SELECT * FROM `freelancer_detail` 
  WHERE f_id = (select freelancer_id 
  from shortlisted_freelancers 
  where shortlisted_id =(SELECT postJob_id from client_detail 
  WHERE client_email = "joshua@gmail.com")) 
  </code></pre>