> Martijn wrote:
> > Jason wrote:
> > > Wow, that's a really lovely result.
> > >
> > > I'll have a looky look.
> > >
> > > When was this type of query acceptable as I don't recall
> > ever using that
> > > kind of a FROM clause before.
> >
> > Firebird 2.0, Release Notes under "Derived Tables". Welcome :-)
> >
> > You have Arno to blame for it too ;)
>
> Pretty darn cool!
>
> Although I'm losing some of my nice dark colored hair over this!
>
> I'm not quite sure how to handle this unusual table name...
>
> Looks like it will end up as an escaped entry in the
> RelAliasList property.

I have it working such that it won't mess up your query and also such that
it stores the value of this derived table as the table name in the
RelAliasList property if for some reason it is needed.

I am considering that KeyLinksAutoDefine will not be in order, as of yet,
for queries with a derived table in it.

This fix will come out in IBO 4.7 Beta12.

Regards,
Jason Wharton