Actually it breaks above 9.
My reasons for this is simply to get everything into one table so that I can display this information to a user who may want to filter on any of those fields and see them in a grid. Unfortunately, I as of yet, have not found a way to sort a grid based on a foreign Id in a child table other than with an SQL statement with an ORDER BY clause.
>Technically, a LEFT or RIGHT JOIN creates a sub-query in order to select matched and unmatched records. According to VFP help, you can only have 2 for each query level.
However, I do have a view that uses LEFT JOIN on the same level 4 times [joining a total of 5 tables]. And, I am sure I have others like this. I suggest you start smaller and work upward to see at what point the SELECT breaks [how many LEFT JOINS actually break the code].
>
>I am sure you have good reason, but why would you want matched and unmatched records from so many tables? IMHO, this is too many records and too much data to try to deal with. Is this for some kind of statistical analyses? Just curious.
Travis Vandersypen