Just a SWAG, but compare the SET('deleted'), SET('ansi') and SET('exact') settings under both versions.
>I have a full join (I know, why is your question... but I actually have a good reason to use one). The syntax is simple
>
>Select *;
>from subscriber full join gifts;
>on subscriber.c_id = gifts.c_id
>
>
>When I run this query in VFP6 the query returns 206,453 records. When I run it on the same data using VFP8.0 it returns 199,181 records.
>
>Any thoughts?
>
>Unfortunately I took over a mess of a system from a previous employee and he has used full-joins in many places, some that I haven't even found yet. If I can't find an answer it will doom me to staying in VFP 6.0 until a rewrite of the system is completed.
>
>Thanks
>
>Mitch
Mark McCasland
Midlothian, TX USA