Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Limitation on number of joins with a SQL-Statement ?
Message
 
 
To
27/01/2000 11:55:57
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00323626
Message ID:
00323640
Views:
16
Hi Bruno,
I don't know of any limit on outer joins (except the entire SQL statement can't be more than 8,192 bytes).

The error you are experiencing is due to the VFP limit of queries within queries.

select * from table1 where field1 in ;
(select field1 from table2 where field2 in ;
(select field1 from table3))

VFP only allows one level of subquerying. You can not go two or more levels deep. Check the complexity of your outer joins and see if you in fact have too many levels. You may have to process some of the queries into temporary cursors and then use those itermediate tables in processing your final query.

HTH,
Larry
Larry Miller
MCSD
LWMiller3@verizon.net

Accumulate learning by study, understand what you learn by questioning. -- Mingjiao
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform