Forum: Datenbanken
Delphi
by DeddyH,
20. Okt 2009
Hm...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?
Forum: Datenbanken
Delphi
by DeddyH,
20. Okt 2009
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 league_id = :internal_league_id
AND round = :cmb_roundsText
Ungetestet, wenn es funktioren sollte, erkläre ich es auch gerne ;)
Tabellenalias vergessen, siehe Posts unten