title: I am extracting two columns using a case statement and selecting them into one single column
body: <p>I have two columns named pno and rno both are varchar which has a order number and now my requirement is</p>
  
  <blockquote>
    <blockquote>
      <p>if rno is not null it should print <strong>Actual Generated</strong>, If its not then its <strong>Forecast Generated</strong>.</p>
      
      <p>if pno is not null then it should print  <strong>Reconciled</strong> else <strong>Forecast Generated</strong>.</p>
    </blockquote>
  </blockquote>
  
  <p>my query is :</p>
  
  <pre><code> select  
         case
          when (pno!=null) then 'Reconciled'
         when (pno=null) then 'Forecast1 Generated'
         when (rno=null) then 'Forecast Generated'
         when (rno!=null) then 'Actual Generated'
         end as Status
   from tablexyz
  </code></pre>
  
  <p>When i am executing it i only get either pno or rno case statements result set.my expected out put should return all the case statements. I could not use and in case statement condition, as i need all the records. 
  I run this on Dbvisualizer.</p>
  
  <p>Thanks in advance.</p>