Bonjour 
J’adore !!
liste des clients français n’ayant que deux contacts :
SELECT s.rowid, s.nom, s.datec, s.fournisseur, s.client, s.fk_pays, pays.label, pays.code
FROM llx_societe as s
INNER JOIN llx_c_country as pays ON s.fk_pays = pays.rowid
WHERE s.client = 1 AND pays.code = 'FR' AND s.rowid IN (SELECT fk_soc
FROM llx_socpeople
GROUP BY fk_soc HAVING COUNT(*) = 2)
ORDER BY s.rowid;
Trop fort 
