title: CAML query with nested ANDs and ORs for multiple fields
body: <p>I am working on proof-of-concept code to dynamically generate CAML based on keywords provided to a highly-specific search web service that I am writing. I am not using the SharePoint-provided search web service for this proof. I have done so already for what I am trying to achieve. From all of my research, I cannot find a close example for what I am trying to achieve, which is to check multiple fields for multiple values. Yes, I have looked on SO already for my answer, including this one: <a href="https://stackoverflow.com/questions/5255143/need-help-on-building-caml-query">Need help on building CAML Query</a>.</p>
  
  <p>With that said, if it is possible, how can the following SQL-like query be written in CAML?</p>
  
  <pre><code>SELECT FirstName, LastName, Description, Profile
  FROM SomeFakeTable
  WHERE (FirstName = 'John' OR LastName = 'John' OR Description = 'John' OR Profile='John')
    AND (FirstName = 'Doe' OR LastName = 'Doe' OR Description = 'Doe' OR Profile='Doe')
    AND (FirstName = '123' OR LastName = '123' OR Description = '123' OR Profile='123')
  </code></pre>