Subject Re: AW: [firebird-support] more then two unions
Author Daniel Rail

At July 25, 2003, 10:34, Klement Guenther - Munich-MR wrote:
> But this one doesn't work at least within IBConsole:

> select 'ident', count(*) from identtab
> union
> select 'name', count(*) from nametab
> union
> select 'netz', count(*) from netztab ;

The result fields, from all the selects in the union, must match in
data types and sizes. In the first select, 'ident' is 5 characters and
in the remaining selects, 'name' and 'netz', are 4 characters. Add a
space at the end of 'name' and 'netz', so that they are 5 characters
in length, as follows: 'name ' and 'netz '.

Best regards,
Daniel Rail
Senior System Engineer
ACCRA Group Inc. (
ACCRA Med Software Inc. (