select a.emp_no as 'e.emp_no',b.dept_no,c.btype,c.received
from employees a left join dept_emp b on a.emp_no=b.emp_no
left join emp_bonus c on a.emp_no=c.emp_no
where b.dept_no is not null