1 : <cfquery name="horaire" datasource=#Url.Ligue#>
2 : SELECT Semaines.[code semaine] AS Semaine, Plages.heure, Plages.glace, Equipes.skip AS Skip1, Equipes_1.skip AS Skip2, Plages.jour AS jour, Semaines.[date] AS LaDate, Plages.tri, Equipes_2.skip AS Gagnant, Parties.[nulle 1] as Null, Parties.reportee
3 : FROM (Equipes AS Equipes_1 INNER JOIN (Equipes INNER JOIN Paires ON Equipes.[code équipe] = Paires.[équipe 1]) ON Equipes_1.[code équipe] = Paires.[équipe 2]) INNER JOIN ((Semaines INNER JOIN Plages ON Semaines.[code semaine] = Plages.semaine) INNER JOIN (Parties LEFT JOIN Equipes AS Equipes_2 ON Parties.[code equipe gagnante] = Equipes_2.[code équipe]) ON Plages.[code plage] = Parties.[code plage]) ON Paires.[code paire] = Parties.[code paire]
|