SELECT s.code_client as 'CodeClient',s.nom as 'RaisonSociale',sp.lastname as 'Nom',sp.firstname as 'Prenom',s.address as 'Adresse',s.zip as 'CP',s.town as 'Ville',s.email,s.phone,s.client
FROM `llx2_societe` s
LEFT JOIN llx2_socpeople sp ON s.`rowid`=sp.fk_soc
WHERE 1

exporter en csv utf8 puis importer dans excel