Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
What is the max number of table for a UNION
Message
From
26/08/2001 22:51:22
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
What is the max number of table for a UNION
Miscellaneous
Thread ID:
00549324
Message ID:
00549324
Views:
48
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
I am not the most powerful man in this world.
I am not the worst man in this world either.
I just as same as all of you.
I still need to learn from my mistakes...
Next
Reply
Map
View

Click here to load this message in the networking platform