51Testing软件测试论坛

标题: 假设有employees表（包含employee_id、department_id、employee_name）和departmen... [打印本页]

作者: 测试积点老人 时间: 7 天前
标题: 假设有employees表（包含employee_id、department_id、employee_name）和departmen...
假设有employees表（包含employee_id、department_id、employee_name）和departments表（包含department_id、department_name），查询每个员工所属部门的名称和员工姓名

作者: kallinr 时间: 6 天前
SELECT e.employee_name, d.department_name
FROM employees e
JOIN departments d ON e.department_id = d.department_id;

作者: oliver.tang 时间: 6 天前
select …… join

作者: 海海豚 时间: 6 天前
SELECT e.employee_name, d.department_name
FROM employees e
JOIN departments d ON e.department_id = d.department_id;

作者: jingzizx 时间: 6 天前
SELECT e.employee_name, d.department_name
FROM employees e
JOIN departments d ON e.department_id = d.department_id;

作者: 你好浮戈 时间: 6 天前
SELECT e.employee_name, d.department_name
FROM employees e
JOIN departments d ON e.department_id = d.department_id;

作者: litingting0214 时间: 6 天前
SELECT e.employee_name, d.department_name
FROM employees e
JOIN departments d ON e.department_id = d.department_id;

欢迎光临 51Testing软件测试论坛 (http://bbs.51testing.com/)