Fixture List generation using MySQL

[Tompkins Neil]

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