题解 | #查找所有员工
select last_name,first_name,dept_name from employees left join departments as de join dept_emp d on de.dept_no = d.dept_no on employees.emp_no = d.emp_no
select last_name,first_name,dept_name from employees left join departments as de join dept_emp d on de.dept_no = d.dept_no on employees.emp_no = d.emp_no
相关推荐