软件测试论坛 › [测试积点任务] › 假设有employees表（包含employee_id、department_id、employee_name）和departmen...

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

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

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

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;

查看完整版本: 假设有employees表（包含employee_id、department_id、employee_name）和departmen...