|Subject||RE: [IBO] Parsing error for Fb 2.0 with derived tables?|
> 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(*)
> (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.
Jason L Wharton