How can i create a fixture list for a league of 20 teams?

L

lodger

I have a league of 20 different team and i would like to know haw i can
create a fixture list so that every team plays each other twice.

THANKS
 
L

Lynn Trapp

You can probably do it with a Cartesian product similar to this:

SELECT T.TEAM_ID, T.TEAM_NAME AS HOME, T1.TEAM_NAME AS AWAY
FROM TEAMS AS T, TEAMS AS T1
WHERE (([T].[team_name]<>[T1].[team_name]));
 
Top