I'm still confused. If you already have oppo1 and oppo2 in the table on a single row, why do you need a join at all?
Can I see what this would look like: SELECT gameID, teamID, opp1, oppo2 FROM games
If I see the database contents before the joins maybe I can understand what you need to get the output you want.