简单的查询

SELECT
    b.dept_no,
    a.emp_no,
    d.salary 
FROM
    employees a,
    dept_emp b,
    dept_manager c,
    salaries d 
WHERE
    a.emp_no = b.emp_no 
    AND b.dept_no = c.dept_no 
    AND b.emp_no != c.emp_no 
    AND a.emp_no = d.emp_no