title: Multiple row SQL Where clause
body: <p>This is probably a simple SQL statement, but it's been a while since I've done SQL and I'm having issues with it.  I have this table design:</p>
  
  <pre><code> ID   PositionId    Qty     LeagueId
   1        1          1         5
   2        3          2         5
   3        8          5         2
   4        1          6         4
  </code></pre>
  
  <p>What I need to get are all the rows that have specific PositionId's and Qty's.  Something like:</p>
  
  <pre><code> SELECT       ID, PositionId, LeagueId, Qty
   FROM         Lineups
   WHERE        (PositionId = 1 AND Qty = 1) AND (PositionId = 3 AND Qty = 2)
  </code></pre>
  
  <p>What I'm trying to get is LeagueId 5 returned since it has both PositionId of 1 and Qty 1 and PositionId of 3 and Qty 2.  I don't want to use an OR statement because if I change the WHERE to:</p>
  
  <pre><code> WHERE (PositionId = 1 AND Qty = 1) OR (PositionId = 3 AND Qty = 1)
  </code></pre>
  
  <p>Then LeagueId of 5 will still get returned.</p>