Hi Tore,

it was not the problem....

imagine another sample...

select * from mytable  WHERE '0000000015' in (SELECT ciglid FROM mutuelle mut ) INTO CURSOR temp

they are two differents tables .

bernhart


>No need for two select statements in this case.
>

SELECT * from mutuelle WHERE ciglid= '0000000015'  INTO CURSOR temp

>
>SELECT * from mutuelle WHERE '0000000015' in (SELECT ciglid FROM mutuelle mut ) INTO CURSOR temp
>>hi all,
>>
>>what is bad in my sql command ?
>>
>>

>>SELECT * from mutuelle WHERE '0000000015' in (SELECT ciglid FROM mutuelle mut ) INTO CURSOR temp
>>

>>
>>thank in advance
>>
>>bernhart