>>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.
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)
