General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
Another thing you could try (not sure if it will work), but, create local views that have portions of your full SELECT. For example, create a view that is based on 4 tables from the original SELECT. Create another view based on 5 tables from the original SELECT. Create these in a way that you can now create your SELECT based on the two views with a valid and appropriate join condition.
You might have to create 3 views to facilitate this, but I think you get the point.
Good luck.
>I have a SELECT SQL with more then 9 joins, & VFP (of course) gives me an error "SQL: Too many subqueries (Error 1805)". I hope that SYS(3055) can help me but :o(((((.
>So my question is: Is there any way to increase the joins?
>TIA
>
>P.S. I doubt, but I must ask :o))
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only