Stuck on a join

Eiolon · #1 (**permalink**) 08-28-09, 13:09

I have two tables, games and teams. In the games table I have team1 and team2 which are referencing the teams table to get the name of the team.

I always get a empty set returned.

My query:

Code:

SELECT g.team1, g.team2, t.team FROM games g JOIN teams t ON (g.team1 = t.id AND g.team2 = t.id);

if I leave out the AND g.team2 = t.id I can get the first team name but I can't figure out how to get the second name.

r937 · #2 (**permalink**) 08-28-09, 13:59

tip: learn indenting and line breaks

Code:

SELECT t1.team AS team1
     , t2.team AS team2 
  FROM games AS g 
INNER 
  JOIN teams AS t1 
    ON t1.id = g.team1
INNER
  JOIN teams AS t2
    ON t2.id = g.team2

Eiolon · #3 (**permalink**) 08-28-09, 14:15

Thanks very much.

Internet Services

Web Development

Digital Marketing

Consumer Tech