SELECT e.first_name, e.last name, d.department_name FROM employee Th JOIN departments d ON e.department_id = d.department_ _id WHERE d.department_id IN (1, 2, 3);