title: SQL - WHERE (X, Y) IN (A, B)
body: <p>I have some kind of blockage currently.</p>
  
  <p>My theoretic query looks something like this:  </p>
  
  <pre><code>SELECT * FROM Table WHERE X in (a, b, c) AND Y IN (d, e, f)
  </code></pre>
  
  <p>So basically, I want all rows having multiple columns match, meaning:</p>
  
  <pre><code>X,     Y  
  1,     2  
  3,     4  
  5,     6  
  7,     8,  
  9,    10
  </code></pre>
  
  <p>If I want to get all rows where <code>(X=1, Y=2)</code> or <code>(X=5, Y=6)</code>, so X and Y are correlated, how would I do that?</p>
  
  <p>(MS SQL2005+)</p>