OK. Thank you for the information.

--- In firebird-support@yahoogroups.com, Ann Harrison <aharrison@...> wrote:
>
> On Wed, Apr 6, 2011 at 7:20 PM, gymbratjodee <jpage@...> wrote:
> > I am attempting to optimize some queries and procedures by either
> >
> > A) Creating a temp table, inserting key values from a small set of records, then using the temp table as my initial join for child tables
>
> Firebird 1.5 doesn't support temp tables.
> >
> > B) Using a nested select (derived table) to essentially do the same thing
> >
>
> Firebird 1.5 doesn't support derived tables
>
> You can move to Firebird 2.5 which supports both and test the performance
> difference or you can stay with the 10 year old Firebird 1.5 (but why?) and
> try to get the same effect using a view.
>
> Good Luck,
>
> Ann
>