All pastes #184839 Raw Edit

Unnamed

public php v1 · immutable
#184839 ·published 2006-09-28 10:27 UTC
rendered paste body
exmaple of database:statisticsentry_id   player_id  entry_tc_age1          1          102          2          123          1          94          1          485          3          12playerplayer_id  player_name1          john2          bob3          billWhat i want returned:entry_id  player_id  player_name  entry_tc_age5         3          bill        124         1          john        482         2          bob         12SELECT statistics.entry_id,statistics.entry_tc_age,player.player_nameFROM statistics,playerWHERE player.player_id = statistics.player_idGROUP BY player_idORDER BY entry_id DESCReturns:entry_id  player_id player_name  entry_tc_age5         3         bill        122         2         bob         121         1         john        10