Re: Fixture List generation using MySQL

[Peter Brawley]

>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
>