title: Return if all values meet the criteria
body: <p>I am trying to return all rows that have records in the child table where all of them meet the criteria</p>
  
  <pre><code>T1:
  1
  2
  3
  4
  5
  </code></pre>
  
  <p>T2:</p>
  
  <pre><code>T.ID  Id  Value
  1     01  Apple
  1     02  Banana
  2     05  Grapes
  2     07  Kiwi
  2     08  Apple
  3     04  Banana
  3     06  Potato
  4     10  Honeydew
  4     11  Berries
  5     14  Apple
  5     15  Kiwi
  5     16  Radish
  </code></pre>
  
  <p>I need to identify all ids in T1 which are Fruit in T2, 
  T2.value in (Apple,grapes,banana,kiwi,honeydew,berries)<br>
  Desired Output:</p>
  
  <pre><code>1
  2
  4
  </code></pre>
  
  <p>I have tried this:</p>
  
  <pre><code>select t1.id from t1,t2
  where t1.id = t2.id
  and t2.value  in ('Apple','Grapes','Banana','Kiwi','Honeydew','Berries') 
  </code></pre>
  
  <p>but it doesnt return the output I need, it also returns #3&amp;5.</p>