Cool!

Michelle


>Okay....I found a way to make the view without ANY joins....hehehe
>
>>I believe 10. It's been a while, but I had this same problem. IIRC, 10 includes the original table, so it is, in effect, 9 joins.
>>
>>Michelle
>>
>>
>>
>>>What is the limit?
>>>
>>>>>Does VFP have a limit on number of joins you can have in a local view?
>>>>>
>>>>>I'm building one with 10 'left outer joins' and I get an error saying "SQL: To many SubQueries" ... which in itself is kind of bogus since I don't have any real 'subqueries'...but I guessing maybe the problem is with all the joins???
>>>>
>>>>
>>>>Yes, you've hit the limit.
>>>>
>>>>Michelle