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