Nem add vissza mindent.
lásd 10005 emp_no
Cserébe gyors! :P
Rossz a where záradék.
Ővé: 300024 rekord
SELECT `employees`.*, `titles`.`title`, `salaries`.`salary`, salaries.from_date
FROM salaries
LEFT JOIN `titles` ON (`titles`.`emp_no` = `salaries`.`emp_no`)
LEFT JOIN `employees` ON
(`salaries`.`emp_no` = `employees`.`emp_no`)
WHERE
`salaries`.`from_date` = (SELECT max(from_date) FROM `salaries` WHERE `salaries`.`emp_no` = `employees`.`emp_no`)
AND `titles`.`from_date` = (SELECT max(from_date) FROM `titles` WHERE `titles`.`emp_no` = `employees`.`emp_no`)
Enyém: 331603 rekord
SELECT e.*,
(SELECT title FROM titles WHERE titles.emp_no = e.emp_no AND from_date = (SELECT MAX(`from_date`) FROM `titles` WHERE titles.emp_no = e.emp_no)) AS beosztas,
(SELECT salary FROM salaries WHERE `salaries`.`emp_no` = e.emp_no AND from_date = (SELECT MAX(`from_date`) FROM `salaries` WHERE `salaries`.`emp_no` = e.emp_no)) AS fizetes
FROM `employees` AS e
LEFT JOIN `dept_emp` ON (`dept_emp`.`emp_no` = e.emp_no)
LEFT JOIN `departments` AS `departments` ON `dept_emp`.`dept_no` = `departments`.`dept_no`
Eközben az employees tábla: 299512 :)
Na megyek aludni! :P