title: I want to select specific values from a SQL Server table
body: <p>I want to select specific values from a table called <code>Prescriptions</code>. I want to select a patient that is utilizing the following medicines at a certain period in time:</p>
  
  <p>This is the select that I have been using, but it returns patients that are utilizing just one or two of the medicines. I want to be able to bring just the patient that is utilizing both of the medicines:</p>
  
  <pre><code>SELECT MEDICINE, CLIENTNUMBER
  FROM PRESCRIPTIONS  
  where  
  (MEDICINE like 'simvastatin %' OR
  MEDICINE like 'amlodipine%')  
  AND
  DATE between '11/23/2010' and '11/23/2010'
  Group by CLIENTNUMBER, MEDICINE
  Order by CLIENTNUMBER
  </code></pre>
  
  <p>Can anyone help?  Thank you very much!</p>