select
    b.dept_no,
    d.emp_no,
    d.salary
from
    salaries d
    left join dept_emp b using (emp_no)
where
    d.emp_no not in  (
        select
            emp_no
        from
            dept_manager
    )