title: need resultset if status = N, if status = N and status =P the result not display
body: <p>table: master_consmnt:</p>
  
  <pre><code>fra_code    mode       cnum     cost    edate      status
  ET7867FRA   SURFACE     19001   10.000  2014-01-17  P
  ET7867FRA   SURFACE     19005   5.000   2014-01-17  P
  ET7867FRA   SURFACE     19005   10.000  2014-01-17  P
  FRANE3981   SURFACE     19005   0.000   2014-01-17  P
  FRARE5664   SURFACE     19005   18.000  2014-01-17  N
  FRARE5664   SURFACE     19001   14.000  2014-01-17  N
  FRARE5664   SURFACE     180001  38.000  2014-01-17  N
  </code></pre>
  
  <p>I want the below result , please have a close look at master_consmnt table, the table having multiple cnum with status=P or N. We want a result set which has cnum if not status="P" and status="N".</p>
  
  <pre><code>fra_code    mode      cnum  cost    edate           status
  FRARE5664   SURFACE 180001  38.000  2014-01-17  N
  </code></pre>