SQL Abrrage ?

[Ilja]

yo,

SELECT ...
FROM users u
INNER JOIN user_to_tournaments ut ON bedingung
INNER JOIN tournaments t ON bedingung
INNER JOIN tournament_battles tb ON bedingung
WHERE ut.tournamentID = 1
;

lach, vom OUTER JOIN gesprochen, und INNER JOIN geschrieben, muss natürlich heißen:

LEFT JOIN tournament_battles tb ON (tb.opponentID = u.userID OR tb.challengerID = tu.userID) AND tb.tournamentID = t.tournamentID

Ilja