假设有employees表（包含employee_id、department_id、employee_name）和departmen...

测试积点老人 · 发表于 2024-11-7 09:50:48

假设有employees表（包含employee_id、department_id、employee_name）和departments表（包含department_id、department_name），查询每个员工所属部门的名称和员工姓名

游客，如果您要查看本帖隐藏内容请回复

kallinr · 发表于 2024-11-8 09:18:58

SELECT e.employee_name, d.department_name
FROM employees e
JOIN departments d ON e.department_id = d.department_id;

oliver.tang · 发表于 2024-11-8 09:20:39

select …… join

海海豚 · 发表于 2024-11-8 10:54:36

SELECT e.employee_name, d.department_name
FROM employees e
JOIN departments d ON e.department_id = d.department_id;

jingzizx · 发表于 2024-11-8 11:31:35

SELECT e.employee_name, d.department_name
FROM employees e
JOIN departments d ON e.department_id = d.department_id;

你好浮戈 · 发表于 2024-11-8 13:16:30

SELECT e.employee_name, d.department_name
FROM employees e
JOIN departments d ON e.department_id = d.department_id;

litingting0214 · 发表于 2024-11-8 13:54:34

SELECT e.employee_name, d.department_name
FROM employees e
JOIN departments d ON e.department_id = d.department_id;

		自动登录	找回密码
密码			(注-册)加入51Testing

站长推荐 /1