I'm doing the google analytics Coursera certificate, and a came across the next situation in BigQuery.
As you can see I want to do a "inner join" from the departments and employees table, BUT, I'm getting an error, "...was not found in location US".
Am I doing something wrong or missing something? Both of the tables have "data location: US"
SELECT
employees.name AS employee_name,
employees.role AS employee_role,
departments.name AS departmen_name
FROM
employee_data.employees
INNER JOIN
employee_data.departments ON
employees.department_id = departments.department_id
Thanks in advance