SELECT distinct  `job_column`, `id`, `job_date`
from

(SELECT * FROM resume 
LEFT JOIN education ON resume.login = education.login 
LEFT JOIN work ON resume.login=work.login
order by `id`, `work.job desc` ) as initial_selection

order by job_date desc

SELECT * FROM resume 
LEFT JOIN (select max(number), login from education GROUP BY login) AS education ON resume.login = education.login 
LEFT JOIN (select max(number), login from work GROUP BY login) AS work ON resume.login=work.login

	
	SELECT * FROM resume 
	
	LEFT JOIN (SELECT MAX(number) AS max_number, number, education, university, speciality, faculty, yeared1, yeared2, mark 
	FROM education GROUP BY mark) AS education ON resume.mark = education.mark
	
	LEFT JOIN (SELECT MAX(number), organization, office, yearwork1, yearwork2, function, expertise, mark 
	FROM work GROUP BY mark) AS work ON resume.mark = work.mark
	
	ORDER BY `id` DESC LIMIT $start, $num");

	$result = mysql_query("SELECT * FROM education AS t1 
	(SELECT MAX(number) AS max_number, mark FROM education GROUP BY mark) AS t2
	WHERE t1.number = t2.max_number");
	while($row=mysql_fetch_array($result))// берем результаты из каждой строки
	{ echo '<p> Запись id='.$row['number'].' Текст: '.$row['education'].'
	'.$row['university,'].'
	'.$row['speciality'].'
	'.$row['yearwork2'].'
	'.$row['faculty'].' </p>'; }

SELECT t1.* FROM education AS t1 
INNER JOIN
	(SELECT MAX(number) AS max_number, mark FROM education GROUP BY mark) AS t2 ON t1.number = t2.max_number