Subject | RE: [IBO] Parsing error for Fb 2.0 with derived tables? |
---|---|
Author | Jason Wharton |
Post date | 2006-12-24T00:48:10Z |
> I even think you should take advantage of this new feature, Jason. IfMy guess is you are correct and that this would work.
> I recall correctly (no IBO nor Firebird at my parents place where I'm
> now), IBO reports an error if trying to get the record count of a
> UNIONed set. I would expect
>
> select count(*)
> from
> (select a from tablea
> union select b from tableb)
>
> to work with Firebird 2.0 (though, admittedly, I haven't tried)
I'll make a note of this.
Regards,
Jason L Wharton