verknüpfte Abfrage ... Wie macht mans richtig?

[DeddyH]

Hm...

SQL-Code:

SELECT M.id, M.round, T1.Name AS Team_A, T2.Name AS Team_B, M.result_a AS Res_A, M.result_b AS Res_B
FROM matches M
JOIN Teams T1 ON (M.team_a_id = T1.ID)
JOIN Teams T2 ON (M.team_b_id = T2.ID)
WHERE (M.league_id = 1)
AND (M.round = 1)

Kommt dabei etwas heraus?