SELECT * 

FROM 

    clients LEFT OUTER JOIN entrepots

    ON (clients.ville = entrepots.ville)