[feuervogel]

vielleicht so?

SELECT t1.name t1name, t2.name t2name
FROM teams t1,teams t2, games g
where (t1.TeamID = g.home) AND (t2.TeamID = g.away);