Subject Maximum number of union and left join
Author elitalaw
Hi all,

I've tried to execute a query that consist of 18 unions. It gave me
an error 'BAD BLR - invalid stream' and sometimes a lost connection
to the database.
It happened to me before when i tried to create a stored procedure
with more that 20 left joins.
My question is, what is the maximum number of union a query can
contain? the same goes to left join.

thanks,
eLita