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
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=arch...@jab.org
