select salles.nom, etage.nom from salles inner join etage on etage.id = salles.id_etage;