Read this only if you are a mysql expert

Select h.Name as HomeTeam, a.Name as AwayTeam
From teams h
Inner Join games g
on h.code = g.home
Inner Join teams a
on g.away = a.code

This is very helpful, thank you.

When I apply this to my larger set of games however, for some reason I get duplicates and more for most of the resulting rows, only some of the resulting rows are unique. I am using a WHERE clause to equate the home and away teams to the name.

Any ideas why I am not getting unique results?

Yes, but seeing as I'm not an 'expert', you don't want my flavour of help.

This is very helpful, thank you.

When I apply this to my larger set of games however, for some reason I get duplicates and more for most of the resulting rows, only some of the resulting rows are unique. I am using a WHERE clause to equate the home and away teams to the name.

Any ideas why I am not getting unique results?

Duplicates would be indicative of duplicated data in one or more of your source tables or an invalid join in your query.

When you say are using a where clause to equate teams to the name, what do you mean? The SQL statement I provided handled that in the join statements. What are you using as a SQL statement?