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