Hallo,
hier nun des Rätsels Lösung!
SQL-Code:
SELECT matches.id, matches.round, teams.teamname AS
Team_A , teams_1.teamname AS Team_B , matches.result_a AS
Res_A, matches.result_b AS Res_B, matches.m_date, matches.m_time
FROM (matches INNER JOIN teams ON matches.team_a_id = teams.id) INNER JOIN
teams AS teams_1 ON matches.team_b_id = teams_1.id
WHERE (matches.league_id = 1) AND (matches.round = 1);
@Jens: Du meinst das Thema des Threads soll ich ändern???