select 
salaries.emp_no,
salaries.salary,
salaries.from_date,
salaries.to_date,
dept_manager.dept_no

from 
salaries 
join
dept_manager 
on 
salaries.emp_no = dept_manager.emp_no

order by salaries.emp_no

就是要知道表连接的语法就好：

FROM 表1名

JOIN 表2名

ON

表1名.字段名=表2名.字段名