jahogyjaaaaaa.....
Elhagynám a legutolsó bejegyzés keresést és nézném adott dátumra. pl:
select e.*,s.salary,t.title
from employees as e
left join salaries as s
on e.emp_no = s.emp_no
and '2020-10-01' between s.from_date and s.to_date
left join titles as t
on e.emp_no = t.emp_no
and '2020-10-01' between t.from_date and t.to_date;