2 : SELECT Equipes.nom, Equipes.codedivision, Equipes.codeskip, Equipes.code3, Equipes.code2, Equipes.code1, Equipes.code5, Equipes.photo, Ligues.codeligue, Ligues.nom As NomLigue, Ligues.description AS DescLigue, Ligues.plagetype, Divisions.nom As NomDivision, Divisions.description AS DescDivision
3 : FROM Ligues INNER JOIN (Divisions INNER JOIN Equipes ON Divisions.codedivision = Equipes.codedivision) ON Ligues.codeligue = Divisions.codeligue
4 : WHERE Trim(Equipes.codeinterneligue)='#Url.Codeequipe#' AND (Equipes.ligue)='#Url.Ligue#';
5 : </cfquery>
6 : <!-- #Url.Codeequipe# -->
|