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