Yeah, I've checked out it further using the 3054 sys command, it doesn't optimize the query for fox for dos tables. This is only for outer joins, as you have said, inner joins, or no joins, are fine.

Is there no way around this?

Thanks
Kev

>IIRC, there was a problem reported with some slow OUTER JOIN queries in VFP8beta.
>
>>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
>>>>