title: Search for data that meets multiple criteria
body: <p>Trying to extract people in a database that meet a certain criteria. They need to have either x &amp; y, x &amp; z, or x &amp; w. </p>
  
  <p>I've tried using 'in', and 'or' but I'm getting errors, or bad results (some only showing x, not two of the factors)</p>
  
  <pre><code>select*
  
  from
  part pa
  
  where
  pa.code in ('x', 'y') or 
  pa.code in ('x', 'z') or
  pa.code in ('x', 'w')
  </code></pre>
  
  <p>I'm getting a list of everyone it seems, lots only have the code of X, not X &amp; one of the other factors.</p>