REQ. INVALIDESELECT ville.* FROM offre_ville INNER JOIN ville ON offre_ville.id_ville = ville.id_ville WHERE offre_ville.id_offre = ORDER BY ville.nom_ville