题解 | 查找所有员工的last_name和first_name以及对应部门编号dept_no
SELECT e.last_name, e.first_name, d.dept_no FROM employees AS e LEFT JOIN dept_emp AS d ON e.emp_no = d.emp_no
SELECT e.last_name, e.first_name, d.dept_no FROM employees AS e LEFT JOIN dept_emp AS d ON e.emp_no = d.emp_no
相关推荐