What is the output you expect? Did you want each team listed with each other team only once? And not listed as both home and away?
Should t the results include:
Tates Creek Paris Western
and
Paris Western Tates Creek
Because they are technically different, or would you only want one listed? It might be easier to do this with two nested recordsets.
However this might work:
SELECT DISTINCT E.teamID,E.oppo1, ME.oppo2 AS Opponent2
FROM games E, games ME
WHERE E.teamID < ME.teamID
Did this help? Tips are appreciated...
