select distinct nom as name, destination, activite as activity from client, sejour, village where sejour.idc = client.idc and village.idv = sejour.idv