>We have found a discrepancy in the results from SQL Selects in VFP7, depending on whether the files being queried have indexes or not. Try running the following code and see for yourself. I am using VFP7 with the 1st service pack (VFP version: 07.00.0000.9262).
>
>We also tried this with VFP6 SP5 and found even different results. (see comments in following code).
>
>The purpose of these select statements is to locate records that exist in the "left" table that are not in the "right" table.

There's a documented change in the behavior of queries with outer joins involving nulls. I think it's in the Readme file.

Tamar