merci Gregory,

c'est beau !

select  iresidentid , count(distinct nsql  ) ;
	from thankUT GROUP BY 1 INTO CURSOR temp
	set
	SELECT temp
	browse

>>hi all,
>>
>>

>>create cusor thankUT ( iresidentid I , nsql I )
>>
>>*first
>>insert into thankUt ( iresidentid  , nsql  ) values ( 1 , 1 )
>>insert into thankUt ( iresidentid  , nsql  ) values ( 1 , 7 )
>>
>>
>>* second
>>insert into thankUt ( iresidentid  , nsql  ) values ( 2 , 14)
>>insert into thankUt ( iresidentid  , nsql  ) values ( 2 , 14 )
>>insert into thankUt ( iresidentid  , nsql  ) values ( 2 , 8 )
>>insert into thankUt ( iresidentid  , nsql  ) values ( 2 , 7 )
>>
>>

>>
>>i want a sql to have 2 in first exemple
>>i want a sql to have 3 in the second exemple
>>
>>thank in advance
>

>select count(distinct nsql  ) ;
>	from thankUT 
>