select a.dept_no,b.emp_no,c.salaryfrom dept_manager as a join dept_emp as d on a.dept_no=d.dept_no and a.emp_no!=d.emp_no join employees as b on d.emp_no=b.emp_no join salaries as c on b.emp_no=c.emp_no and c.to_date='9999-01-01'; 三个内连接。(1)内连接1:dept_manager和dept_emp。连接点为dept_no,并且e...