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

[Guest]

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

 

[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]));