Hi,

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. (www.accra.ca)
ACCRA Med Software Inc. (www.filopto.com)