select first_name,title,salary,s.to_date
from employees e
inner join titles t on e.emp_no = t.emp_no
inner join salaries s on e.emp_no = s.emp_no
where e.emp_no = 10001
select first_name,title,salary,s.to_date
from employees e
inner join titles t on e.emp_no = t.emp_no
inner join salaries s on e.emp_no = s.emp_no
where e.emp_no = 10001