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, however VFP6 does not.
Has there been any change in the way LEFT OUTER JOINS work in a SELECT statement in VPF7?
e.g. SELECT table1.* ;
FROM table1 ;
LEFT OUTER JOIN table2 ;
ON table1.key = table2.key ;
AND table2.data = "X" ;
INTO CURSOR my1 NOFILTER
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, however VFP6 does not.
Has there been any change in the way LEFT OUTER JOINS work in a SELECT statement in VPF7?
e.g. SELECT table1.* ;
FROM table1 ;
LEFT OUTER JOIN table2 ;
ON table1.key = table2.key ;
AND table2.data = "X" ;
INTO CURSOR my1 NOFILTER