SELECT * 
FROM (
    clients JOIN entrepots
    ON clients.ville = entrepots.ville)