>I Have a new clue... I think this is probably an easy one but I don't know it...
>
>If you are joining two tables on fied A, and field A has a value in table 1 and is null in table 2...
>
>The where clause is "where 1.a <> 2.a" and in VFP6 this is returning the records, in VFP8 it is not!
>
>Any new thoughts???

Only the following from the VFP7 Help:
Because there were several instances where SQL SELECT statements could return incorrect result sets in previous versions of Visual FoxPro, several changes were made in Visual FoxPro 7.0. You should verify that your SQL SELECT statements return expected result sets.