>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