Worked like a charm! Thanks a million!
SELECT Games.gm_date, Games.tm_id,
Home.tm_div, Home.tm_conf, Games.gm_oppid,
Opp.tm_div AS opp_div,
Opp.tm_conf AS opp_conf
FROM Games
INNER JOIN Teams AS Home
ON Games.tm_id = Home.tm_id
INNER JOIN Teams AS Opp
ON Games.gm_oppid = Opp.tm_id...