You have not said anything about any error message. Your original query

> select count(*) table_1 union
> select count(*) table_2 union
> select count(*) table_3 ;

should not work, since you have no FROM clause. I assumed that was a typing
mistake and that your question was purely theoretical, if you have a
practical problem, then you ought to tell us about how it manifests itself.

Set

At 14:39 25.07.2003 +0200, you wrote:

>Hi Richard,
>
>I have to be more precise on my question.
>I typed it into IBConsole's SQL-window, so it may be a problem to
>IBConsole and not to Firebird.
>
> > I have a query which is built up of a dynamic number of unions which
> has got
> > to 35 unions in it with no problems on FB 1.5RC3