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.
Mark McCasland
Midlothian, TX USA