title: Not found: Table unit5-336819:employee_data.employees was not found in location US
body: <p>This is the code below.</p>
  <p>One solution I tried was to open up a new query so I could get the exact location for each table. I then copied that below and it would not work either.</p>
  <p>I also made sure that the location was USA and then not USA and neither solution worked. The certificate course recommends doing this:</p>
  <p>If the BigQuery editor flags the table names in your query as unrecognizable, include the dataset name by substituting employee_data.employees for the employees table and employee_data.departments for the departments table, as shown in line 6 and line 8 below:</p>
  <p>However, this does not solve the problem either.</p>
  <p>The tables are in the same database. Can anyone help me with this? I have even used single quotes around the table after the from statement and that doesn't work either.</p>
  <pre><code>SELECT
      employees.name AS employee_name,
      employees.role AS employee_role,
      departments.name AS department_name
  FROM 
      employee_data.employees
  INNER JOIN
      employee_data.departments 
  ON
      employees.department_id = departments.department_id;
  </code></pre>