According to BOL the maximum number of tables per SELECT statement is 256. I
don't think there's any other limit specific to UNION statements.

--
David Portas
------------
Please reply only to the newsgroup
--

"Fabrizio Regio" <fabrizioregiohotmail.com> wrote in message
news:2c7601c33fa2$e42a86f0$a601280aphx.gbl...
> Exists a limit on the number tables present in union
> statement?
>
> Thk.