考察内连接与左/右联结区别

select e.last_name,e.first_name,d.dept_no
from employees e left join dept_emp d on e.emp_no=d.emp_no