>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

SELECT * FROM orditems WHERE 'ERNSH' IN (SELECT cust_id FROM orders)

Error: SQL: Queries of this type are not supported

Supposed to be:

SELECT * FROM orditems WHERE order_id IN (SELECT order_id FROM orders WHERE cust_id='ERNSH')