I'm looking at a routine / script to create the fixtures like team 1 vs team 2 team 3 vs team 4 team 5 vs team 6 etc
> > > > On Thu, Aug 19, 2010 at 3:44 PM, Peter Brawley < > peter.braw...@earthlink.net> wrote: > >> >> >> I'm tasked with generating a list of fixtures from a table of teams, >>> whereby >>> each team plays each other home and away. Does anyone have any >>> experience >>> generating such information using MySQL ? >>> >> >> Basically ... >> >> select a.id,b.id from tbl a join tbl b on a.id<b.id; >> union >> select a.id,b.id from tbl a join tbl b on a.id>b.id; >> >> PB >> >> ----- >> >> >> On 8/19/2010 9:12 AM, Tompkins Neil wrote: >> >>> Hi, >>> >>> I'm tasked with generating a list of fixtures from a table of teams, >>> whereby >>> each team plays each other home and away. Does anyone have any >>> experience >>> generating such information using MySQL ? >>> >>> Thanks for any input. >>> >>> Regards >>> Neil >>> >>> >
