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;
题目解答注意:易错点是有些员工是没有分配部门的select e.emp_no,d.dept_no,eb.btype,eb.receivedfrom 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;