未被识别的姓名：员工在[9：8] [英] Unrecognized name: employees at [9:8]

问题描述

这给了我一个无法识别的名称错误。为什么？

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

Unrecognized name: employees at [9:8]

enter image description here

推荐答案

您在完整的表引用之后缺少别名employees和departments！您在ON子句中使用了它们，但您没有定义它们！

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

这篇关于未被识别的姓名：员工在[9：8]的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！