Join / Union

[kado]

Any idea why Cognos only allows you to join (or union) 2 queries at a time? I can't figure it out and am curious.

-thanks-

[Suraj]

You can UNION as many queries as you want. Only JOIN is limited to two at a time. I think it is to reduce sql complexity and incorrect data aggregation.