Well, this app was developed in v6.0 and ran fine then, I'm now testing the same project using VFP8 beta to see how it copes.

Kev

>Kevin,
>
>I'm still not sure if you consider it a problem in VFP8beta or with query itself. Did you try to run it under VFP6 or whatever VFP version you're using?
>
>>I haven't got version 7, we are bypassing it.
>>
>>I don't think it is the UNION now, I'm having a similar experience with another select (contains joins).
>>
>>It seems to be when I run selects from Fox for dos tables and JOIN them with VFP tables.
>>
>>Kev
>>