title: Distinct results based on another row's values
body: <p>In this example, is there a way to find only those distinct ID's which are connected to banana and orange? So in this case, the result would be ID 2 and 3 (but not 4, because it has apple as well).</p>
  
  <pre><code>id      fruit
  
  1       apple
  1       banana
  2       banana
  2       orange
  3       banana
  3       orange
  4       apple
  4       banana
  4       orange
  </code></pre>