Hi Fabio,

You are right...

VFP doesn't support search literal value in subquery.
it was my problem


bernhart



>>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
>
>VFP doesn't support search literal value in subquery.
>
>Better if you rewrite with with its true meaning
>< returns all records of mutuelle if there is at least one record with ciglid = '0000000015 ' >
>

>>SELECT * from mutuelle WHERE EXISTS(SELECT * FROM mutuelle WHERE ciglid = '0000000015' ) INTO CURSOR temp
>