This is called derived tables. Not available in v1.5.2 of Firebird and
lower. It's previewed to be available on v2.

On Mon, 28 Mar 2005 12:31:24 -0500, Jason Dodson wrote:

>
>I know of nothing like this in Interbase, but most instances Ive seen
>doing this can be avoided (much like a goto).
>
>Are you using ADO to interface with the database? If so, I seem to
>remember the ADODB.Recordset object having a OpenRecordset function,
>which I always assumed was to do a query of a query.
>
>Check and see if whatever tools you are using client side supports this.
>You may be suprised.
>
>Aaron Abend wrote:
>> SQL Server allows you to create a table "on the fly" and select from it, as
>> in...
>>
>> Select count(*) from (select mycol from mytable where ...) VirtualTableName
>>
>> My particular query is much more complex than this simple example. The
>> result I need cannot be obtained without this kind of structure or something
>> like it. I did get it working by creating a view called VirtualTableName,
>> so that is my current workaround, but if someone knows a better solution, I
>> would be grateful.
>>
>> Specifically, is there some "into .." command that would work here? Note
>> that I do not want to do this in a stored procedure, so that presents
>> another limitation.
>>
>> Thanks,
>>
>> Aaron
>>
>>
>>
>>
>>
>>
>> Yahoo! Groups Links
>>
>>
>>
>>
>>
>>
>>
>>
>>
>
>
>
>
>Yahoo! Groups Links
>
>
>
>
>
>
>