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