第20关讲解示例中员工表employees与部门表departments关联查询cross join结果错误

liyupi / sql-mother

免费的闯关式 SQL 自学教程网站，从 0 到 1 带大家掌握常用 SQL 语法，纯前端实现，简单易学~

http://sqlmother.yupi.icu

3.34k stars 367 forks source link

Open DF-22 opened 1 year ago

DF-22 commented 1 year ago

第20关讲解示例中，员工表employees与部门表departments关联查询结果错误

SELECT e.emp_name, e.salary, e.department, d.manager
FROM employees e
CROSS JOIN departments d;

中e.department应更正为d.department