title: Oracle query self-join?
body: <p>I've simplified this example but hopefully the example provides enough substance to make sense.</p>
  
  <p>If I have a table such as the following...</p>
  
  <pre><code>ITEM GROUP
  ---- ----- 
   A     1
   B     1
   C     1
   D     2
   E     2
   F     3
   G     4
  </code></pre>
  
  <p>... and I am provided items A, B, D and F, I would like to contruct a query that will return those details along with the additional items in the associated groups, C and E. </p>
  
  <p>It seems that I should be able to do some sort of inner join but I'm not clear on how it could be done.  It would be best if this were done in a single query due to the constraints of the environment.</p>
  
  <p>Thanks much!</p>