var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: league type database
Ok, a newbie here but ive done a search and not found anything like what I need, so here goes
I am currently constructing a DB to enter in football (soccer info)
What I am getting stuck on is a table to list all the games
team1 v team2
team1 v team3
team1 v team4
team20 v team19
This will consist of 20 teams times 38 games.
Rather than type in 760 records manually, is there an update query that could generate this table for me.
At present I have a table to contain all the teams
and the table to get updated
HomeTeamID ... same as teamID
AwayTeamID ..... same as teamID
Can this be done???
any help appreciated
aaahhh, I think i am on the right track
in a new query I have added the tbl_Teams twice and put the same field from each table. However this has only generated 400 entries, Half of what I need.
Also team1 vs team1
team2 vs team2 are still present
Any advise grateful