title: SQL question conjunction
body: <p>Let's say you have a simple table with two fields: account and item:
  An account can have multiple items.  For example:</p>
  
  <pre><code>Account    Item
  11         Apples
  11         Pears
  11         Crackers
  12         Apples
  12         Bannanas
  12         Cookies
  13         Pears
  13         Carrots
  13         Apples
  </code></pre>
  
  <p>How would I write a query so that I could select all accounts with some specified set of items.   For example, how would I write  query so that I would select accounts where the fields are assigned both Apples and Pears (in the example accounts 11 and 13).</p>
  
  <p>Thank you for your help.</p>
  
  <p>Elliott</p>