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_id  player_name  entry_tc_age
5         3          bill        12
4         1          john        48
2         2          bob         12






SELECT statistics.entry_id,
statistics.entry_tc_age,
player.player_name
FROM statistics,
player
WHERE player.player_id = statistics.player_id
GROUP BY player_id
ORDER BY entry_id DESC

Returns:

entry_id  player_id player_name  entry_tc_age
5         3         bill        12
2         2         bob         12
1         1         john        10