问未识别姓名：[9:8]雇员

EN

SELECT 
    employees.name AS employee_name,
    employees.role AS employee_role,
    departments.name AS department_name
FROM 
    `strange-calling-318804.employee_data.Employees` as employees
    JOIN 
    `strange-calling-318804.employee_data.departments` as departments 
    ON employees.department_id = departments.department_id

SELECT e.name AS employee_name, e.role AS employee_role,
       d.name AS department_name
FROM `strange-calling-318804.employee_data.Employees` e JOIN
     `strange-calling-318804.employee_data.departments` d 
     ON e.department_id = d.department_id;