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 ')' at line 1 select js.nm_jante, js.id_jante, ma.marque, mo.modele from jantes js join autoexclusive.jantes ji on js.nm_jante=num_jante left join autoexclusive.marques_jantes ma on ji.id_marque=ma.id left join autoexclusive.modeles_jantes mo on ji.id_modele=mo.id where js.nm_jante in ()