>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