Skip to main content
Known Participant
July 29, 2006
Question

Database Question

  • July 29, 2006
  • 1 reply
  • 196 views
I have a table called team (team_id, team_name, win, loses, tie) and a game table (game_id, game_date). How can I build displau in Coldfusion showing games played orderred by best win records
I m thinking to desgin a relational table r_game_team that wud have score too in it and have team_id and game_id
Is there any other way I should design the table?
This topic has been closed for replies.

1 reply

Inspiring
July 29, 2006
You seem to be on the right track. You might want to add another field for win lose or draw. Then you can take it out of the team table. It would probably be easier to maintain your data that way.