SELECT .code_ AS code_echelle, .lib_ AS lib_echelle, ( ( (t2.cNbClasse1)-(t1.cNbClasse1) ) / (t1.cNbClasse1) ) * 100 AS evo_0_4, ( ( (t2.cNbClasse2)-(t1.cNbClasse2) ) / (t1.cNbClasse2) ) * 100 AS evo_4_10, ( ( (t2.cNbClasse3)-(t1.cNbClasse3) ) / (t1.cNbClasse3) ) * 100 AS evo_10_25, ( ( (t2.cNbClasse4)-(t1.cNbClasse4) ) / (t1.cNbClasse4) ) * 100 AS evo_25_100, ( ( (t2.cNbClasse5)-(t1.cNbClasse5) ) / (t1.cNbClasse5) ) * 100 AS evo_100_et_plus, ST_AsGeoJson(.SHAPE) AS geom FROM INNER JOIN ( SELECT .*, .cCode FROM LEFT JOIN ON AND cAnnee = '' ) AS t1 ON .code_ = t1.cCode INNER JOIN ( SELECT .*, .cCode FROM LEFT JOIN ON AND cAnnee = '' ) AS t2 ON .code_ = t2.cCode GROUP BY .code_ Erreur Mysql : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AS code_echelle, .lib_ AS lib_echelle, ( ( ' at line 2