VFP7 handles LEFT OUTER JOINS a little different to VFP6.
If you have a WHERE in a SELECT statement with a LEFT OUTER JOIN, referring to the right table, VFP6 will treat nulls different to VFP7. Therefore in VFP6, you may receive more records from your select statement, than in VFP7.
I have a SELECT statement with a LEFT OUTER JOIN and a AND clause refering to the right table.
I have noticed that in VFP6, I obtain one set of results and in VFP7 I obtain a different set of results with the same SELECT statement.
VFP7 adds in the NULL values from the right side of the join...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.