title: return condition if item exists
body: <p>I have this query:</p>
  
  <pre><code>select colA, colB
  from tableA
  where colB in ('catA','catB')
  AND
  colA in ('value1', 'value2', ..., 'value999') 
  </code></pre>
  
  <p>Right now, this query displays a record valueX satisfies the first where condition.  </p>
  
  <p>How can I modify this so that the query will show ALL 999 valueX and a Yes/No column if it meets the <code>colB in ('catA','catB')</code> requirement?</p>