[SQL] Inner Join Anweisung?!

[nachti1505]

SQL-Code:

SELECT spielid, 
            (SELECT liga FROM liga WHERE ligaID = s.ligaID), 
            (SELECT team FROM team WHERE teamid = s.heimteamID), 
            (SELECT team FROM team WHERE teamid = s.auswaertsteamID) 
FROM spiele s