2. ASPRunnerPro General questions
  3. My SQL Query
This topic is locked

My SQL Query

 		9/3/2008 12:59:05
ASPRunnerPro General questions
A
 ashumak author

A little of the path, but if anyone can help me...
I have a table (teaminfo) with fields for players names (p1surname, p1name, p2surname, p2name, etc...) and I want to build a query to compile all the players in all the teams in one alphabetical list.
Suggestions on how to do it?
Sergey Kornilov admin 9/3/2008

You cannot.
Players should reside in a separate table.

Team table - general team info

Player table - players by table
Team and Player table should be linked as Master-Details.
A
 		ashumak author 9/3/2008

OK, So I break the team table into three...team, players, coaches,...but how do I set up a page to allow a teams information to be added all on one page? Or can I?
Sergey Kornilov admin 9/3/2008

What team info includes?

Who is allowed to add a new team?

Do you need to register first in order to add a team?
PS. If you like to sort players by name you MUST use a separate players table.