SELECT s.emp_no, s.salary 
FROM employees e, salaries s
ON e.hire_date = s.from_date
AND e.emp_no = s.emp_no
ORDER BY s.emp_no DESC