upper limit on SQL query size
From: abracad <abracad_at_hotmail.com>
Date: Sat, 14 Jul 2001 21:32:35 GMT
Message-ID: <3b50ba69.4251099_at_news.freeserve.net>
Date: Sat, 14 Jul 2001 21:32:35 GMT
Message-ID: <3b50ba69.4251099_at_news.freeserve.net>
I am working on an application that requires a number of SQL queries to be joined with UNION ALL statements.
Is there an upper limit as to how many can be joined in SQL? Or in MS Access?
On my computer Access cannot process more than about 20 queries joined together. I would like to know if this is an Access restriction, an SQL one, or just my computer. Received on Sat Jul 14 2001 - 23:32:35 CEST