HelenDev - 3:14 pm on Oct 8, 2010 (gmt 0) [edited by: engine at 4:12 pm (utc) on Oct 8, 2010]
Thanks for the replies guys, I think I have been able to find the solution.
Enigma, wouldn't that only give me one result rather than the whole staff list?
The penny has finally dropped that I needed to do this the other way around - select all the rows from employee_reviews rather than employees...
$mods_query = 'SELECT
MAX(employee_reviews.year) AS latest_review
RIGHT JOIN employees ON employees.id=employee_reviews.employee_id
GROUP BY employee_reviews.employee_id';
[edited by: engine at 4:12 pm (utc) on Oct 8, 2010]