title: Check if a result set has specific values
body: <p>I want to know what is the best way to check if a subquery has a set of values. I came up with the following query but I don't think its efficient. </p>
  
  <pre><code>SELECT * FROM SomeTable 
  WHERE 
  (
      2 IN (SELECT OptionId FROM Table2 WHERE Table2_Id = 1) AND
      3 IN (SELECT OptionId FROM Table2 WHERE Table2_Id = 1)
  )
  </code></pre>
  
  <p>I appreciate if anyone can provide me with a better solution. </p>
  
  <p>Thanks</p>