Erreur SQL !<br>select distinct t.type_nav,  as lib, couleur from types_navigation t, sessions s where t.type_nav = s.type_nav and t.type_nav <> 0 and id_spot = 1894 and floor(t.type_nav /10) * 10 in (20, 30, 40, 70, 90, 100, 140, 150) and not isnull(ventMin) and not isnull(ventMax) order by 2<br>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 lib, couleur from types_navigation t, sessions s where t.type_nav = s.type_na' at line 1