Query for basketball game

Oddish · #1 (**permalink**) 01-08-04, 07:06

I've got a table containing basketball games and a table containing teams (se picture). I would like some help with a query that will select all the information from the games table and also get the names of the teams playing. The teams are as you can see referensed by "hometeam" and "awayteam" in "games". Is this even possible?

Oddish · #2 (**permalink**) 01-08-04, 07:37

Wow, I'm better at this than I thougt!

It suddenly just came to me! I would however appreciate some feedback on this SQL. Is is an ok query or can it be optimized in some way?

Code:

SELECT g.*, t1.name AS hometeam, t2.name AS awayteam
FROM (games AS g INNER JOIN teams AS t1 ON g.hometeam = t1.teamid)
INNER JOIN teams AS t2 ON g.awayteam = t2.teamid

Internet Services

Web Development

Digital Marketing

Consumer Tech