BigQuery - JOIN function 'Unrecognized name'

Viewed 19

I'm taking Google's Data Analysis Certification. During a lesson, we use JOIN on two tables (employees and departments) from the employee_data dataset. Even if I type the query as shown in the course, the query isn't done as I get this message: Unrecognized name: employees at [8:7]. What am I doing wrong?

enter image description here

SELECT 
  name AS employee_name,
  role AS employee_role,
  departments.name AS department_name
 FROM `liquid-muse-362023.employee_data.employees` 
 INNER JOIN
  `liquid-muse-362023.employee_data.departments` 
  ON (employees.department_id = departments.department_id)
0 Answers
Related