SELECT cnosecretaraitSocial,COUNT(cnosecretaraitSocial) AS cntSoc FROM Employee GROUP BY cnosecretaraitSocial INTO CURSOR cSocial SELECT cNom,cnosecretaraitSocial,cSocial.cntSoc; FROM Employee; LEFT JOIN cSocial ON cnosecretaraitSocial == cSocial.cnosecretaraitSocial; GROUP BY cNomIs this works for You?