how to solve this unrecognized name error?
I got the following error: Unrecognized name: employees at [9:4], couldn’t figure out what’s wrong.
SELECT
employees.name=employees_name,
employees.department_id=employees_department_id,
employees.role=employees_role,
departments.name=departments_name
FROM `sql-beginner-334118.employee_data.employees`
INNER JOIN
`sql-beginner-334118.employee_data.departments`
ON employees.department_id = departments.department_id