No, it will not work with subquery. As I said in this reply, you will get error:
"SQL: Queries of this type are not supported"

>>>Hi Jun,
>>>
>>>It would be helpful to know what is not working properly with this query.
>>>What results are you expecting, and what results are you getting instead?
>>
>>I got error: "SQL: Queries of this type are not supported"
>>
>>This works:
>>SELECT * FROM tableA WHERE RECNO() IN (2,5,100,300)
>>will give me rows 2, 5, 100 and 300 from tableA
>>
>>but then I can only have up to 24 recno listed, so I hope the subquery will work but it will not.
>
>You can use IN with a sub-query. Perhaps this might work:
>
>

>SELECT * FROM TableA where recno() in (select MyRecno from ListOfRecnos)
>

>
>However, selecting records by recno() is frequently fraught with problems.
>
>HTH, Hilmar.