Game schedule

from the Artful Common Queries page


List all possible home-away encounters of teams listed in a table.
SELECT t1.name AS Visiting,
       t2.name AS Home
FROM teams AS t1
STRAIGHT_JOIN teams AS t2
WHERE t1.ID <> t2.ID;

Last updated 22 May 2009




Return to the Artful Common Queries page