employees表里面的所有都显示，
employees在左边
所以 left join

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