SELECT 

    C.nom_client , D.nom_client , C.ville_client

FROM 

    clients C

RIGHT OUTER JOIN 

    distributeurs D

ON 

    C.ville_client = D.ville_distrib