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.

Regards,
Jason Wharton