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
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