title: SQL Left join Query Issue
body: <p>I have the following tables</p>
  
  <pre><code>Users
  ID Name
  1  John Smith
  2  James Jones
  3  Peter Brown
  
  Purchases
  USERID   NAME
  1        Apple
  1        Pear
  1        Banana
  2        Apple
  2        Pear
  3        Apple
  </code></pre>
  
  <p>How can i have a sql query that returns users that brought (apple &amp; pear &amp; banana) </p>
  
  <p>So in the above tables it would return only 'John Smith'</p>
  
  <p>Thanks</p>