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