I'm working on a SQL query that involves INNER JOIN, and I want to make sure I understand it correctly. Here's the query:
SELECT employees.employee_id, employees.employee_name, departments.department_name
FROM employees
INNER JOIN departments
ON employees.department_id = departments.department_id;
Could you explain the purpose of the INNER JOIN in this query and what kind of result it would produce? I'm trying to grasp the concept better. Thanks!