title: Should search whole table and give data in one row according to the condition
body: <p>I have a table with values as follows:</p>
  
  <pre>
  AC_NO  INV_NO   CC      FT
  --------------------------------
  1      A        PTN     INVOICE
  1      A        PTN     BDE
  2      B        ABC     INVOICE
  2      B        PTN     INVOICE
  2      B        PTN     BDE
  </pre>
  
  <pre><code>SELECT
  ac_no,
  CASE  
  WHEN FT like '%INVOICE%' THEN 'AVAILABLE' else 'NOTAVAILABLE'
  END AS INVOICE ,
  CASE  
  WHEN FT like '%BDE%' THEN 'AVAILABLE' else 'NOTAVAILABLE'
  END AS BDE
  FROM Account_info where CC='PTN';
  </code></pre>
  
  <pre>
  Output 
  ------------------------------------
  1   A   Available      Notavailable
  1   A   Notavailable   Available
  2   B   Available      Notavailable
  2   B   Notavailable   Available
  </pre>
  
  <p>but I need them in the following  format:</p>
  
  <pre>
  AC_NO   INVOICE       BDE
  --------------------------------
  1       AVAILABLE     AVAILABLE
  2       AVAILABLE     AVAILABLE
  </pre>