>Hi,
> What is the max number of table for a single UNION ?
>I have the code
>

>SELECT * FROM csrOpenSum ;
>UNION ;
>SELECT * FROM csrInvoiceSum ;
>UNION ;
>SELECT * FROM csrTransferInSum ;
>UNION ;
>SELECT * FROM csrTransferOutSum ;
>UNION ;
>SELECT * FROM csrHisRunOutSum ;
>UNION ;
>SELECT * FROM csrLogFileLPSum ;
>UNION ;
>SELECT * FROM csrAdjAddSum ;
>UNION ;
>SELECT * FROM csrAdjMinusSum ;
>UNION ;
>SELECT * FROM csrSalesSum ;
>UNION ;
>SELECT * FROM csrReturnSum ;
>UNION ;
>SELECT * FROM csrCNSum ;
>INTO CURSOR csrTotalSum
>

>Thank you

One less than you need. < s > Seriously. I do believe it's 10 total tables (1st table plus 9 UNIONS.)