exmaple of database: statistics entry_id player_id entry_tc_age 1 1 10 2 2 12 3 1 9 4 1 48 5 3 12 player player_id player_name 1 john 2 bob 3 bill What i want returned: entry_id player_name entry_tc_age 5 bill 12 4 john 48 2 bob 12 SELECT DISTINCT player_id, entry_date, entry_tc_age, entry_id FROM statistics GROUP BY player_id ORDER BY entry_id DESC Returns: entry_id player_name entry_tc_age 5 bill 12 2 bob 12 1 john 10