From: Peter Brawley
Date: August 19 2010 2:44pm
Subject: Re: Fixture List generation using MySQL
List-Archive: http://lists.mysql.com/mysql/222592
Message-Id: <4C6D4354.8040601@earthlink.net>
MIME-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit



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