Delphi-PRAXiS - Einzelnen Beitrag anzeigen

**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

nachti1505 Registriert seit: 7. Apr 2007 188 Beiträge Delphi 7 Enterprise	#2 Re: [SQL] Inner Join Anweisung?! 24. Okt 2008, 10:51 markieren 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
	Zitat

Einzelnen Beitrag anzeigen

Re: [SQL] Inner Join Anweisung?!