SELECT * FROM TB_MATCH_EVENT, TB_TEAM, TB_PLAYER
WHERE TB_MATCH_EVENT.PLAYER_1 = TB_PLAYER.PLAYER_ID
AND TB_PLAYER.TEAM_ID = TB_TEAM.TEAM_ID
AND TB_MATCH_EVENT.MATCH_ID = '93969'
ORDER BY EVENT_TIME, EVENT_ID
Matchstatistik
A-laget - KSS Klimat & Styrsystem ( - )