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

测试积点老人

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

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

kallinr

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

oliver.tang

select …… join

海海豚

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

jingzizx

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

你好浮戈

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

litingting0214

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