select nom
from pokemon p LEFT JOIN apparition a
ON P.id = a.idPokemon && (SELECT DISTINCT idEmplacement FROM Apparition); 