So I am trying to follow along with a tutorial on SQL joins but when I try to run the query in which I join two tables I get the aforementioned error.
I have confirmed that the dataset does indeed reside as you can see in the following screenshot: [The dataset details page]
The query in question is the following:
SELECT emp.name, dept.name, emp.name FROM `project-id.employee_data.employees` as emp INNER JOIN `project-id.employee_data.departments` as dept ON emp.department_id = dept.department_id
If I try to query either table individually, I don’t have any problems. It is only when I query them in the same place that it gives me an error. I made sure processing location is set to US in the query settings so location shouldn’t be an issue.