title: WHERE_IN query with a composite key?
body: <p>Let's say I have a table with a two-part composite key, and 4 records, like the following:</p>
  
  <pre><code>KEY_PART_1 KEY_PART_2
  A          1
  B          1
  C          2
  C          3
  </code></pre>
  
  <p>I want to write some dynamic SQL to select only the records B,1 and C,2 using a "WHERE IN" clause, <em>without</em> selecting A,1 or C,3.</p>
  
  <p>Is there some way to do this without a temp table?  </p>
  
  <p>Not that it matters, but we are currently using Oracle, and hoping to move to PostgreSQL soon.</p>