内连接法:select e.last_name,e.first_name,d.dept_no
from employees as e
join dept_emp as d on e.emp_no = d.emp_no
where e.emp_no = d.emp_no