title: display 3 different columns from 3 different rows
body: <p>I have a table structured as below:</p>
  
  <hr>
  
  <h2>leaveTypeID   |  employeeID  | balance  | status  |</h2>
  
  <p>1             | AT0000004    |2         |1        |<br>
  2             | AT0000004    |1         |1        |<br>
  3             | AT0000004    |3         |1        |<br>
  1             | AT0000008    |2         |1        |<br>
  2             | AT0000008    |2         |1        |<br>
  3             | AT0000008    |2         |1        |</p>
  
  <p>This is the table schema:</p>
  
  <hr>
  
  <p><strong>leaveTypeID</strong>(PK) | <b>employeeID</b>(PK) | balance | status |</p>
  
  <hr>
  
  <p>Now I want to to display in my view 
  Leave Balance of AT000004 as:</p>
  
  <p><strong>CL: 2
  SL: 1
  EL: 3</strong> </p>