SQL: Unrecognized name: employees at [9:3]

James Hill 0
Viewed 32

I am currently working on using inner joins in SQL, I have attempted to used aliases to fix this problem but it just changes the name that is "unrecognizable". Database name is employee_data. Table names are employees and departments. The error is being picked up on the last line of code. Any suggestions would be appreciated.

SELECT
employees.name as employee_name,
employees.role as employee_role,
departments.name as department_name
FROM
`project-1-357623.employee_data.employees`
INNER JOIN employee_data.departments 
ON
employees.department_id = departments.department_id;
sql
1 Answers

Hi Please try this code

enter code here

SELECT employees.name as employee_name,
employees.role as employee_role,
departments.name as department_name
FROM employees
INNER JOIN departments
ON employees.department_id = departments.department_id
Hosein Hamedan0
Related