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
>