SQL实战56.获取所有员工的emp_no

题目

解答

注意：易错点是有些员工是没有分配部门的

select e.emp_no,d.dept_no,eb.btype,eb.received
from dept_emp as d left join employees as e on d.emp_no=e.emp_no
                   left  join emp_bonus as eb on e.emp_no=eb.emp_no;