Thanks - I am going to use views for now since that will require the least
amount of restructuring when fb2 comes out.

Thanks,

Aaron



-----Original Message-----
From: Ann W. Harrison [mailto:aharrison@...]
Sent: Monday, March 28, 2005 12:58 PM
To: firebird-support@yahoogroups.com
Subject: Re: [firebird-support] Tables "on the fly" in Firebird?


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

>

The "select ... from (select...)" syntax is called derived tables and is
supported in Firebird 2.0. The alternative is to restructure the query
- where possible - into joins or create a view of the inner select.


Regards,


Ann




Yahoo! Groups Links