01.$sql = "Select absence_no, stdate, endate, status,
02.CASE type_no
03.WHEN 'sck' THEN 'ลาป่วย'
04.WHEN 'EN' THEN 'English'
05.WHEN 'US' THEN 'United states'
06.ELSE 'Unknown'
07.END as type_no
08.from employee
09.Inner Join absence on employee.employee_id=absence.employee_id Where employee.employee_id='".$_SESSION['employee_id']."'";
