Here's what I've gathered so far:

It's whenever you do a select from a Fox4Dos table that includes a JOIN, it's as if it doesn't optimize the query.

I suppose you could easily try this by creating a couple of fox4dos tables and seeing if you get the same problem.

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
>>