#get employees and there roles SELECT `emp_id`, `name`, `phone`, `email`, e.`created_at`, `dep_name`, `sec_name`, CASE WHEN es.is_head = 1 THEN 'Head Section' ELSE 'Staff' END AS positions FROM `departments` d JOIN `employees` e JOIN `sections` s JOIN `employee_section` es WHERE d.dep_id = s.department_id AND e.emp_id = es.employee_id AND s.sec_id = es.section_id #get only employee head sections SELECT `dep_name`, `sec_name`, `name`, `phone`, `email` FROM `departments` d JOIN `sections` s JOIN `employees` e WHERE d.dep_id = s.department_id AND e.emp_id = s.head_sec_id #tracking employee information SELECT s.sec_id, s.sec_name, CASE WHEN (es.is_head = 1) THEN 'Head Section ' ELSE 'Staff' END AS employee_role, e.name AS employee_name, es.start_date, es.end_date FROM employee_section es JOIN employees e ON es.employee_id = e.emp_id JOIN sections s ON es.section_id = s.sec_id;