SELECT customer.customer_id, customer.last_name, customer.first_name, customer.email, customer.ssc_id, customer.category, department.department FROM department INNER JOIN customer ON department.id = customer.department_id