从两表中选择三个需要的字段，并通过where限定范围

select e.last_name, e.first_name, d.dept_no 
from employees as e, dept_emp as d
where d.emp_no=e.emp_no