This should work

select c.game_id, a.team_name as home_team, b.team_name as away_team

from dbo.teams a

inner join dbo.teams b on 1 = 1

inner join dbo.schedule c on c.home_team_id = a.team_id and  c.away_team_id = b.team_id

Replace the brackets with parenthesis