title: How to handling if subquery returns multiple value
body: <p>I have a stored procedure in which I'm using sub query, but the issue is that my sub query returns 2 values and I've to return all records based on these two values.</p>
  
  <pre><code>Select * from [Address] where AddressID=
  (Select AddressID from PersonAddress where PersonID=
  (select Claimant from [Case] where CaseID=35))
  </code></pre>
  
  <p>In this query AddressID returning two values and both the value having record in table, I've to return both the address.</p>
  
  <p>How can I solve this?</p>