select em.last_name,em.first_name, de.dept_no
from employees as em join dept_emp as de
on em.emp_no = de.emp_no
where de.emp_no is not null
select em.last_name,em.first_name, de.dept_no
from employees as em join dept_emp as de
on em.emp_no = de.emp_no
where de.emp_no is not null
牛客博客，记录你的成长
京公网安备 11010502036488号