He should also not forget to use the NOFILTER clause to make his temporary cursor.

He may be able to do his query in one SELECT statement, depending on what he wants to do, which isn't fully described. It depends on the JOIN and other things.

>Hi!
>
>No, it is not possible to do. You can, however, select the data into temporary cursor, then get data in next SELECT statement from that cursor.
>
>Unlike VFP, SQL Server is glad to run things like this...
>
>>Hi there,
>>I'm trying to nest a couple of SELECT structures, and it’s not working. Is it possible to select from a select in VFP?.
>>
>>If my English is not good enough, what I need to do is something like:
>>
>>Select lista.cod, b.*
>>From lista, (select * from lista2) as b
>>
>>I know you can SELECT from the WHERE statement, but can you do a SELECT from the FROM statement?
>>
>>Thx in advance