>There appears to have been a change in the behaviour of
>SQL - SELECT when using a WHERE clause in a Left/Right outer
>join. An example is shown below. Surpringly, this behaviour
>change is not noted in the "What's new in Visual FoxPro"
>documentation released with VFP7. Does anyone know if this
>was an intentional but undocumented change or not? The new
>behaviour seems to make sense but I imagine it would break
>some existing code as we have unfortunately discovered.
Intentional: I was the one who filed the bug on it. MSKB#
Q268022 explains it in more detail. VFP7 and SQL Server agree in their handling of the data now.