两表 inner join 连接

select a.emp_no,a.salary,a.from_date,a.to_date,b.dept_no from
((select * from salaries) a
inner join 
(select * from dept_manager) b
on a.emp_no=b.emp_no )
order by a.emp_no