title: Access SQL Query - Only extracting value if it is same for the whole group
body: <p>I'm trying to write a query in Access 2010 based on the following simple data set:</p>
  
  <pre><code>**Lot   Fruit**
  1   Mango
  1   Mango
  1   Apple
  1   Orange
  2   Apple
  2   Apple
  2   Apple
  3   Apple
  3   Mango
  4   Mango
  4   Mango
  4   Mango
  5   Apple
  5   Apple
  </code></pre>
  
  <p>I only want to extract those <code>Lot no.</code> where fruit has only one type within each <code>Lot</code>. </p>
  
  <p>For example, say I want to get data where <code>Fruit = "Apple"</code>, then it should only pull data where Lot has only "Apple" no other fruit in the same Lot.</p>
  
  <p>In our example if I want all lot which have only Apple, then query should bring the following result.</p>
  
  <pre><code>Lot Fruit
  2   Apple
  2   Apple
  2   Apple
  5   Apple
  5   Apple
  </code></pre>
  
  <p>I have tried various SQL queries but with no luck, any help will be appreciated.</p>