title: select rows with same id but different value in other column and specify column values
body: <p>I have a table like this:</p>
  
  <pre><code>+------+------+
  |Product|Warehouse|
  +-------+------+
  |1      |A     |
  +-------+------+
  |2      |A     |
  +-------+------+
  |3      |A     |
  +-------+------+
  |1      |B     |
  +-------+------+
  |2      |B     |
  +-------+------+
  </code></pre>
  
  <p>I would like to select the Product that occurs more than once with the different Warehouse.</p>
  
  <p>The output should be something like:</p>
  
  <pre><code>+------+------+
  |Product|Warehouse|
  +-------+------+
  |1      |A     |
  +-------+------+
  |1      |B     |
  +-------+------+
  |2      |A     |
  +-------+------+
  |2      |B     |
  +-------+------+
  </code></pre>
  
  <p>This gets me part way there:</p>
  
  <pre><code>SELECT *
  FROM YourTable
  WHERE Warehouse IN (
      SELECT Warehouse
      FROM YourTable
      GROUP BY Warehouse
      HAVING COUNT(*) > 1
  )
  </code></pre>
  
  <p>But I would also like to specify a set of values for Warehouse. So what I want to do is see products that exist in multiple warehouses, but I want to be able to specify which warehouses I want to see.</p>
  
  <p>I will be using Oracle SQL Developer.</p>