Yes, I have struck this issue, my solution was to create a view of the 4 or
so which do work, and make the final join with the view.
Not sure what caused it but the view solution worked for me

Alan

> -----Original Message-----
> From: Andreas [mailto:andreasfurrer@...]
> Sent: Friday, 27 June 2003 7:56 PM
> To: firebird-support@yahoogroups.com
> Subject: [firebird-support] Connection to firebird server 1.02/1.03
> dropped on complex SQL-Query
>
>
> I have a complex SQL-Query (using Delphi with BDE) with a lot of
> sub-queries. The query is a UNION of 5 select statements.
>
> If I execute the command the connection to the firebird server is
> immediately dropped.
>
> If I reduce my query to only 4 select statements, the query works.
>
>
> Are there any parameters (server side or client side) which I need to
> change? Or what else can I do?
>
>
> Thanks from Germany.
>
>
>
> To unsubscribe from this group, send an email to:
> firebird-support-unsubscribe@yahoogroups.com
>
>
>
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
>
>
>