title: Combining First Two Cases in Mysql
body: <p>I have a MySQL query part which has</p>
  
  <pre><code>$PendingNewquery = "
          CASE
              WHEN s.pending='Y' THEN 'P'
              WHEN MAX(fqc.ChangeTime) IS NULL THEN 'N' 
              WHEN s.Pending='Y' OR MAX(fqc.ChangeTime) IS NULL THEN 'PN'
          END
  </code></pre>
  
  <p>I am not getting any results for 'PN' which combines first two cases. How can I do that without using <code>WHERE</code>? </p>