如何在SQL中使用JOIN语句

发布于 2025-02-11 16:20:36 字数 367 浏览 2 评论 0原文

我正在研究一个具有两个表格的员工_DATA数据集；员工和部门。我正在尝试使用Department_ID作为主要密钥加入员工表的数据到部门表。它不断给我一个错误消息。请我在哪里想念它？

SELECT name AS departments_name, 
(
  SELECT name AS employees_name,
FROM `my-first-analysis.employee_data.employees`
)
FROM `my-first-analysis.employee_data.departments` 
JOIN departments ON departments.department_id = employees.department_id

原文

I'm working on an employee_data dataset which has two tables; employees and departments. I'm trying to join data from the employee table to the departments table using department_id as the primary key. It keeps giving me an error message. Please where am I missing it?

SELECT name AS departments_name, 
(
  SELECT name AS employees_name,
FROM `my-first-analysis.employee_data.employees`
)
FROM `my-first-analysis.employee_data.departments` 
JOIN departments ON departments.department_id = employees.department_id

分享到QQ

分享到微博

如果你对这篇内容有疑问，欢迎到本站社区发帖提问参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。

发布评论

需要登录才能够评论，你可以免费注册一个本站的账号。

夜空下最亮的亮点 2025-02-18 16:20:36

像这样：

SELECT departments.name AS departments_name,
      employees.name AS employees_name,
From employees
Left JOIN departments ON departments.department_id = employees.department_id

Like this:

SELECT departments.name AS departments_name,
      employees.name AS employees_name,
From employees
Left JOIN departments ON departments.department_id = employees.department_id

回复收藏 0 原文

~没有更多了~